Spell check with protection on

[Mona]

I have a worksheet that I have protected and allow users
to access on the unlocked cells to enter data. My users
want to use the spell check function, but it is not
allowing them to spell check. Any ideas?

 

[Paul B]

Mona, here is one way using a macro to unprotect the sheet run spell check
and the protect the sheet, I am not sure but I think in later versions of
excel there might be a option for this when you protect the sheet

Sub Spell_Check()
'spell check a protected sheet
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
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **