Protected spreadsheet with spellckeck

[Debbie K.]

I protect worksheets which makes the cursor hop from one unprotected cell to
the next, in sequence, as I want it to, in order for users to complete the
sheet. How do you enable the spell check function while the worksheet is
protected for the users to check their spelling?

Thanks for your assistance.

Debbie K.

 

[Paul B]

Debbie, you could unprotect the sheet check the spelling and then protect
the sheet, like this

Sub test1()
ActiveSheet.Unprotect password:="123"
Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC",
IgnoreUppercase:=False _
, AlwaysSuggest:=True
ActiveSheet.Protect password:="123"
End Sub

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[pfsardella]

These two threads provide an explanation and a workaround. The second
provides a macro that will allow spell checking the cells that were
available for adding data.

http://www.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&safe=off&th=9b897b3a95c9afea&rnum=1
http://groups.google.com/groups?threadm=O4wpEVUdCHA.1656@tkmsftngp11

If you're unfamiliar with using macros, David McRitchie has a nice
writeup for an introduction.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

HTH
Paul

 

[Debbie K.]

I clicked Tools, Macro, record new macro, gave it a name and nothing
happened. My spreadsheet was there, but where do I copy the macro to?

Would it be to much trouble for you to give exact directions (ste by step)
because I have never worked with macros.

I appreciate all your help.
Debbie

 

[Paul B]

Debbie, here you go

To put in this macro, from your workbook right-click the workbook's icon and
pick View Code. This icon is to the left of the "File" menu this will open
the VBA editor, in the left hand window click on your workbook name, go to
insert, module, and paste the code in the window that opens on the right
hand side, press Alt and Q to close this window and go back to your workbook
and press alt and F8, this will bring up a box to pick the Macro from, click
on the Macro name to run it. You can also assign it to a button on your
sheet. If you are using excel 2000 or newer you may have to change the
macro security settings to get the macro to run.
--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Debbie K.]

Thank you very much Paul!!!! I works fine. One thing. When I protected
it, I did not give a password and it seems to have done it all by it
self........Am I going crazy?

 

[Paul B]

Debbie, the macro put the password on the sheet, if you don't want a
password then use this

Sub test1()
ActiveSheet.Unprotect
Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", _
IgnoreUppercase:=False _
, AlwaysSuggest:=True
ActiveSheet.Protect
End Sub

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Debbie K.]

It all worked, thank you very much!!!!!!!!!!

One more small thing??? Because I could not figure out how to name the
macro, it named itself. How do I change the name of the macro?

I do appreciate all of your help.
Debbie

 

[Paul B]

Debbie, something like this
Sub My_Macro()
--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **