spell check protected document

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
 
P

Paul B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spell Check 5
Spell Check on Excel document 2
Spell Check with protected sheets 3
Spell check when worksheet is protected 3
Spell check strings 2
Spell Check Protect Reprotect with same settings 1
Spell check flagging words I can't find in Excel 3
Spell Check Unlocked Cells Only 9

Top