Sportingspaniel, here is one way
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"
--
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
"Sportingspaniel" wrote in
message ...
Hi.
I want to a macro (for activex control) that will spell check a password
protected document. I have locked certain cells that contain formulas
(numerical) but other cells have manual input (text) which needs spell
checking. I want a macro for my Button that will spell check and print
(printing not a problem, it just wont spell check password protected doc).
Any suggestions?
Thanks
|