spell check protected document

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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