spell checking in protected sheet

[Lauren]

I have protected a worksheet and left certain ranges
unlocked. One of the unlocked ranges contains text
explanations that will be periodically updated by various
users. I have discovered that even though these cells are
unlocked, spell check is unavailable. I have changed the
sheet protection to allow cell formatting, but this did
not solve the problem. The people typing into these cells
want to use spell check and I cannot figure out how to
make it available without leaving the whole sheet
unprotected

 

[Paul B]

Lauren, here is one way, the macro will unprotect the sheet, check the
spelling and then protect the sheet, password for the sheet is set to 123,
assign it to a button on your sheet. If everthing is spelled right you want
see anything when this is ran.

Sub Check_Spelling()
ActiveSheet.Unprotect password:="123"

Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC",
IgnoreUppercase:=False _
, AlwaysSuggest:=True, SpellLang:=1033

ActiveSheet.Protect password:="123"
End Sub

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