Hi Paul, thank you sooo much.

I don't want to be a bug, but where do I begin with that Sub Spell_Check ()??

I'm still a bit confused.

"Paul B" wrote:

Jimjam, one way,

Sub Spell_Check()

'spell check a protected sheet

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


"jimjam" wrote in message
...
I cannot use the spellcheck function on a protected sheet? HELP!