Spell Check w/Sheet Protection

[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 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.

 

[Paul B]

Debbie, one way would be to unprotect the sheet check the spelling and then
protect the sheet with a macro, like this

Sub spellcheck()
ActiveSheet.Unprotect
Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC",
IgnoreUppercase:=False _
, AlwaysSuggest:=True
ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True
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.]

Thank you for your assistance. However I am totally ???? I tried entering in
the macro and it keep responding with Compile Error: Syntax Error.. I should
add this is my first macro in excel. Any other assistance would be greatly
appreciated.

 

[Debbie K.]

Thank you for your assistance. However I am totally ???? I tried entering in
the macro and it keep responding with Compile Error: Syntax Error.. I should
add this is my first macro in excel. Any other assistance would be greatly
appreciated.

 

[Paul B]

Debbie, try this I think the word wrap got the other one

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

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. 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.]

I typed exactly as you listed below, but I kept getting error messages. I
have not worked with macros. Is there another way to do this.

Your help is greatly appreciated.

 

[Bernard V Liengme]

Debbie,
Time to take the plunge and dive into macros.

Let's first make sure you are putting the macro in the right place.
With only the Excel file of interest open, use ALT+F11 to open the Visual
Basic Editor.
Now click on the Insert menu item, and select Module from the drop down
menu.
Now you are ready to enter the code

I expect the problem is with line breaks that our e-mail programs add to
messages. Here it is with line numbers. Just do a copy and paste (from this
message to the Visual Basic Editor), then edit the macro so each line in the
Visual Basic Editor starts with a number. Now delete the numbers.

0 Sub spellcheck()
1 ActiveSheet.Unprotect
2 Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC",
IgnoreUppercase:=False _
3 , AlwaysSuggest:=True
4 ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True
5 End Sub

Return to the worksheet and use ALT+F8 to open the macros menu. Select the
spellcheck macro and clcik the Run button. It worked well for me on a
protected worksheet.

Time for a coffee break - you are now a macro user!
PS the code is staight from Paul's message.

Best wishes
Bernard

 

[Debbie K.]

Bernard,

First of all I want to thank you for these basic instructions. I copied and
pasted into Visual Basic Editor and deleted the numbers as indicated. Now,
when I go back to my excel spreadsheet and use ALT+F8 the macro menu does
open, but the name of my macro is not there. Don't I have to save the macro
while in visual basic editor? Then when I open the macro window the name
will appear? I can not find out how to save the macro. My help in visual
is not loaded and will not be for a few weeks. Also, a pop up window
appears and says that I have to unhide the sheet.....I did not hide the
sheet. Next question is should my spreadsheet be protected or unprotected
when I try all of this. I think it should be protected, correct?

Thank you again and look forward to hearing from you soon.

Debbie

 

[Debbie K.]

Bernard,

I don't know how, but I have the macro when I click ALT+F8. I select RUN
and my spreadsheet disappears and my e-mail pops up. My spreadsheet is on
my toolbar and the bottom of my screen and when I open it the spellecheck is
not highlighted to use. Am I getting closer?

Thanks again,
Debbie

 

[Bernard V Liengme]

Sounds as if the macro is in the wrong place. Please send me the file (my
private e-mail - remove caps from below)
Unprotect sheet first so I can have a look at it. If data is confidential
send a simalr file.
Bernard

 

[Debbie K.]

Your e-mail address is (e-mail address removed)???????? I tried the one listed
below of (e-mail address removed) and it did not work.

Thanks,
Debbie

 

[Debbie K.]

Bernard,

I have tried the e-mail address listed below and it keeps coming back
undelivered.

Thanks,
Debbie