With a worksheet protected, is there a way to spell check entries in cells
that are not protected?

dvs, Not without VBA, you could use some code to unprotect the sheet run
spell check and then protect the sheet like this

Sub Spell_Check()

Const Password = "123" '**Change password here**

ActiveSheet.Unprotect Password:=Password

Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC",
IgnoreUppercase:=False _

, AlwaysSuggest:=True

ActiveSheet.Protect Password:=Password

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 2002 & 2003


"dvs_47" wrote in message
...
With a worksheet protected, is there a way to spell check entries in cells
that are not protected?

You can use this macro to unprotect, run the spellcheck, then re-protect the
sheet.


Sub Spell_Check()
ActiveSheet.Unprotect Password:="justme"
Cells.CheckSpelling SpellLang:=1033
ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _
Contents:=True, Scenarios:=True
End Sub


Gord Dibben Excel MVP




On Mon, 6 Mar 2006 09:34:39 -0800, dvs_47
wrote:

With a worksheet protected, is there a way to spell check entries in cells
that are not protected?

Gord Dibben MS Excel MVP