spell checking in protected sheet

  • Thread starter Thread starter Lauren
  • Start date Start date
L

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
 
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 **
 
Back
Top