Spell Check in Protected Work Book

Hi,
How can I leave spell check available for a range of cells while protecting 
the rest of the sheet?

0
Utf
1/16/2010 1:17:01 AM
excel.worksheet.functions 4936 articles. 2 followers. Follow

2 Replies
1988 Views

Similar Articles

[PageSpeed] 57

Hi Chris. 

I have just conducted a simple test whereby I restricted access to 3 cells 
but left the rest of the  Worksheet available for edit. 

In the above circumstances the Spell Checker is greyed out so it appears 
that you are not able to do what you are looking for. 

If my comments have helped please hit Yes. 

Thanks. 

"ChrisK" wrote:

> Hi,
> How can I leave spell check available for a range of cells while protecting 
> the rest of the sheet?
> 
0
Utf
1/16/2010 9:39:01 AM
Using a macro is the only work around that I know of.

Sub Spell_Check() 
    ActiveSheet.Unprotect Password:="justme" 
    Cells.CheckSpelling SpellLang:=1033 
    ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _ 
            Contents:=True, Scenarios:=True 
End Sub 

Unprotects the sheet, does the spellcheck then reprotects the sheet.

"justme" can be changed to your password.


Gord Dibben  MS Excel MVP

On Fri, 15 Jan 2010 17:17:01 -0800, ChrisK
<ChrisK@discussions.microsoft.com> wrote:

>Hi,
>How can I leave spell check available for a range of cells while protecting 
>the rest of the sheet?

0
Gord
1/16/2010 9:22:09 PM
Reply:

Similar Artilces:

Checking if user has admin privileges
Vista 7 I wonder if checking the ability of writing to Windows registry is a good method to determine user;'s privileges. I appreciate your comments, Claire Claire escribi�: > Vista 7 > > I wonder if checking the ability of writing to Windows registry is a good > method to determine user;'s privileges. > I appreciate your comments, > Claire http://vbnet.mvps.org/index.html?code/network/isuseranadmin.htm That is not what I am asking for. Claire "Eduardo" <mm@mm.com> wrote in message news:hfa29l$cef$1@aioe.org... >...

protecting a group of cells not a whole worksheet
I would like to protect a group of cells and not a whole worksheet but I haven't been able to figure out how to do this. I think this would be the best way for what I am wanting to do. I have a spreadsheet that I send to 13 people. They make changes and send back to me and then I have to up-date the changes. If I could protect all the cells except for the one they enter in - then I could save the file on a shared drive and it would eliminate me up-dating. Is there a way to do this? Hi select the cells for which you want to allow entries. After this goto 'Format - cells - Protection&...

Check Names Will Not Let Me Send Email
Hello, I am trying to send an email. I have entered an email address in the to section that I do not want to save to my contacts file. Outlook will not let me send unless I do. This was not happening before last week when my computer crashed and was fixed. How do I get Outlook to let me send my email without saving the contact? My contacts files will become huge if I have to save the email address of every single person I write to. Please help. And thanks in advance. Candy "Candy" <Candy@discussions.microsoft.com> wrote in message news:1841587...

Publisher Web Site Doesn't Work
I created an awesome website with Publisher and Published it locally just to view it. None of the graphics show up and no links show up. All I can see is text and the background. All files are there and in their proper place and the xml file list is there with all files listed. It clearly knows where to get the files because it's pulling the background and text - why isn't it showing graphics and links etc? Please help - I don't want to lose my budding techy enthusiasm!!! When you Publish to the Web, Publisher 2003 produces an index.htm file and an index_files folder i...

Sorting the "My Work" or "Customers"
Hi, The default setting for the My Work is: Activities Calendar Queues Articles Reports Announcements The default setting for Customers: Accounts Contacts Is there a way to change order of these? Thanks Hello katrinathompson, yes you can change it in the sitemap.xml regards Mario > Hi, > > The default setting for the My Work is: > Activities > Calendar > Queues > Articles > Reports > Announcements > The default setting for Customers: > Accounts > Contacts > Is there a way to change order of these? > > Thanks > ...

data duplication check ?
Hi all, I have this code which runs a macro to add a complete list of all data for 'today' to be entered into a sepeate worksheet which is called the database. Is there a way, if so how, that the code can be changed so that if the 'same' data is entered twice a pop up message box is shown to alert the user of this and stop this happening. The code I have is Sub add_Anydays_jobs() With ActiveSheet.Range("A8:N34") Sheets("Log").Range("A" & Rows.Count).End(xlUp).Offset( _ 1, 0).Resize(.Rows.Count, .Columns.Count)....

345 free programming books
Check it out, ^_^ http://ttcom.blogspot.com/2006/04/345-free-online-programming-books.html ...

home renovation job quote work sheet
I'm looking for a reno work sheet. Google for it. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "scottturner" <scottturner@discussions.microsoft.com> wrote in message news:98ADDA05-6B1B-45E6-81A0-94EFB4B64C3D@microsoft.com... > I'm looking for a reno work sheet. ...

does the /cleanprofile command line switch work with Outlook 2010?
I deleted the registry entries for Outlook without backing up my registry (as I should have), and I am now looking for a way to restore them. From my research, it looks like the "/cleanprofile" command line switch would do the trick. However, when I try it with Outlook 2010, I get an error message saying the argument is not valid and to verify it. Am i using the argument with improper syntax? Is it still available with this version of Outlook? If it is no longer supported with 2010, is there a replacement that does the same thing? Am I going down the wrong path ...

Activating groups i protected sheet
Hi I have several groups in a worksheet. The sheet is also protected, but this prevents me from activating (opening/closing) the groups. How do i cirkumvent this, without un-protecting the sheet? Thanks! /Sune If you already have the outline applied, you can protect the worksheet in code (auto_open/workbook_open??). Option Explicit Sub auto_open() With Worksheets("sheet1") .Protect Password:="hi", userinterfaceonly:=True .EnableOutlining = True End With End Sub It needs to be reset each time you open the workbook. (excel doesn't remember...

Using Outlook 2002 @ work and home
I have Outlook 2002 running on an XP Pro laptop. At work the laptop is in a AD domain(wired), and at home the laptop is using a Linsys wireless router for connectivity. Using Outlook at work is fine. I can send and receive messages without a hitch. The problem is when I leave my domain at work. I cannot send emails if I try to send mail to a recipiant that dosen't have my suffix of @pellatn.com. The weird thing is that I can receive mail from anyone. I don't understand why I can receive mail from any address, but I'm limited to sending messages to my fellow pellatn...

Cuztomization wont work with Outlook client
Hi, We have made new button in account form that opens new .aspx page. Page reads values from the account form where I was when I pushed the button. This works ok if i'm using it with IE, But if I try to use it with outloook client, the .aspx page opens ok but it cant read any values from the account form? It doesnt give any error messages, but the fields where it should read values from account form are empty. any idea what could be the problem? Is it something to do with outlook using http://localhost:2525... and IE using http://crm... if so is there some settings I need to change o...

Sync has stopped working
For several months, I have been able to sync Entourage with my Palm m130. Just last week, the conduit started crashing. I have figured out that it happens when syncing my calendar. All other parts of Entourage sync just fine. Has anyone else had this problem? Any help would be greatly appreciated. Please e-mail me at greg.mcbride@e-commedia.com if you have any suggestions. Thanks, Greg McBride Make sure all of your recurring events have end-dates attached. Events without end dates can cause crashes during the synchronization process. An easy way to find them is to go to Edit -> Advance...

Old application won't work under Vista.
I have Windows Vista Home Premium SP1 (32-bit) and am trying to run an old OCR application. I run it in Win95 compatibility mode. Most functions of the old application work in Vista, but it fails if I ask it to acquire an image from the scanner. I am asked to select my twain source, which I do (Samsung SCX4100), but then the scanner gives a couple of grunts and a message box from Vista says "Twain.dll Client's 32-Bit Thunking Server has stopped working". I close the box, am told to check for Windows updates, and finally (when I try clicking around on the applicatio...

check numbering #2
We were printing checks and came to check number 9999. Instead of advancing to 10000, the check numbering started over at 0001. Does anyone know of a way to fix this without printing the checks through 9999 and then manually changing the number in the checkbook maintenance screen before printing the remainder of the checks? If you pad your check numbers with zeros, you won't have this problem. ie. 0009999 -- Japheth Nolt Microsoft SBF Specialist Landis Computer www.landiscomputer.com "Carol" <Carol@discussions.microsoft.com> wrote in message news:1AC9C25F-C44D...

how can i check my yahoo mail from outlook?
i have a problem of checking my email from both yahoo and hotmail? what shall i do? Use your browser instead. Outlook is for POP mail, not web mail. "daniel hassanian" wrote: > i have a problem of checking my email from both yahoo and hotmail? > what shall i do? "daniel hassanian" <daniel hassanian@discussions.microsoft.com> wrote in message news:67A7F745-2C04-4B92-8F1A-978D61250894@microsoft.com... > i have a problem of checking my email from both yahoo and hotmail? > what shall i do? Exactly what is the problem? Do you know or have the mail servers ...

Copy + Quote
the function Ctrl + " to copy the cell above does not work on my home computer to copy a cell above. On all other computers I've used this shortcut works. What can I do to fix this? -- Thanks, Yo ...

Refresh data in Protected worksheet
Does the work sheet protection work properly when refreshing data from access. I have the range I want to refresh Unlocked and unhidden and the rest of the worksheet protected, but when i refresh it tells me the worksheet is protected and I cant refresh. Is there something I'm missing or is this a shortcoming of worksheet protection? KT just hazarding two guesses. are you talking about a macro that does it? if so... are you providing a password to unprotect before you refresh the data? ActiveSheet.Unprotect "password" 'your refresh code would go after the above sta...

Powerpoint freezes on Imac but keynote works
I receive Powerpoint presentations on mu Intel Imac by email through Yahoo. When I try to open the presentation with Powerpoint 2004, the program freezes after displaying only part of the first screen. I can open the presentations without problems with Keynote (I can use it only for a month), so it is definitely a Powerpoint problem. Both Office 2004 and the Mac are updated up to date. Any ideas? Henri When you open the presentation in Keynote, can you re-save it in PowerPoint format? (I don't use Keynote so I can't test this out myself.) If you can, try that and then open the...

Check Register Entry Question
After downloading transactions from my bank to MS Money 2002, each transactions text data (name of company the check or debit card was paid to, etc.) are placed in my memo field. I then have to manually go the Name field to enter the name of the company. Does anyone else have this problem? How can I force Money to import the name of the company the check or debit card was written to, into it's proper place. Quicken has always placed it correctly, saving me considerable time. Thank you. In microsoft.public.money, Mick wrote: >After downloading transactions from my bank ...

Fix the 1099 MISC process so it works with all boxes available
the 1099 Misc form/reporting is designed to report many things. Great Plains should fix its system so it allows for completion of the 1099 misc form as directed in the instructions. One vendor may have multiple payments that need to be reported in a 1099 misc form, ex Rent box 1, Royalty box 2, nonemployee compensation box 7. The instructions for form 1099 misc gives an example of machine rental with operator: machine in box 1 operator in box 7. I don't see this as an enhancement to your program. I see this as making your program work, otherwise you should quit saying you hav...

Sync SQL to Exchange Address Book
Can someone please guide me on how to synchronize contacts from a SQL database to Exchange 2003 Global Address List? I never worked with Exchange servers, so I also need to know how to set up a Global Address List? Thanks, Eric "eric.nguyen312@gmail.com" <eric.nguyen312@gmail.com> wrote: >Can someone please guide me on how to synchronize contacts from a SQL >database to Exchange 2003 Global Address List? I never worked with >Exchange servers, so I also need to know how to set up a Global Address >List? You won't be working with any Exchange servers to do ...

BCC not working
I enter the main email address, than continue with the others on the BCC line. Email1; email2; etc. I than click on Hide BCC. After sending, I can go to my sent file, and all the BCC emails show listed in the BCC line. Bob On Fri, 30 Jul 2010 13:19:22 -0400, "The Dog Breeders List" <rltutt@earthlink.net> wrote: >I enter the main email address, than continue with the others on the BCC >line. Email1; email2; etc. I than click on Hide BCC. After sending, I can go >to my sent file, and all the BCC emails show listed in the BCC line. Umm... Yeah, that...

Credit Limit does not work properly
The credit limit I set for my debtor in GP9 does not work properly. It asks for password when raising invoice even though the customer has sufficient credit balance. What do I do? Here is the draft KB I have written on the subject.... will be published soon. Information about the Credit Limit feature used in Receivables Management and National Accounts in Microsoft Dynamics GP ======================================================================================================================== Summary -------- Microsoft Dynamics GP has a Credit Limit feature which allows a Customer...

UserAccounts.CommonDialog
Sure would oblige a message box returning the full path of a file browsed. -- Thanx & Best Regards, Not sure what the question is and why want to use the UserAccounts CommonDialog Guessing, if you want to browse to a file with a view to opening it, try something like this - Sub getOpenFile() Dim sFile As String Dim vReturn As Variant vReturn = Application.GetOpenFilename() If VarType(vReturn) = vbBoolean Then MsgBox "User cancelled" Else sFile = vReturn MsgBox sFile End If End Sub See GetOpenFilename in help and ...