Spell check in a Protected worksheet

H

Hayden

Hi,

I would like to know how to do a Spell Check in Excel, when your worksheet is protected. At the moment the only way to do a Spell Check is if I unprotect my sheet, so this defeats the purpose of a protected sheet! I thought I had fixed it when I checked the box (Under: Protect Sheet: Allow all users of this worksheet to: Format Cells) Format Cells, but this only allows the user to fiddle with the basics (Font Size,Type,Alignments,Colours of Fonts, ect).

If anyone has any tips, I would be most grateful!
 
J

Jim Rech

I don't think there is a way to do a spellcheck on a protected worksheet.
In cases like this you have to give users a macro that does the
unprotecting, the operation, and then reprotects. In this case:

Sub MySpellCheck()
ActiveSheet.Unprotect
CommandBars("Tools").Controls("Spelling...").Execute
ActiveSheet.Protect
End Sub
 
F

Frank Kabel

Hi Jim
this won't work on a non Egnlish Excel version. I would remove
CommandBars("Tools").Controls("Spelling...").Execute

with
activesheet.usedrange.CheckSpelling
 
Top