Spell check with protection on

M

Mona

I have a worksheet that I have protected and allow users
to access on the unlocked cells to enter data. My users
want to use the spell check function, but it is not
allowing them to spell check. Any ideas?
 
P

Paul B

Mona, here is one way using a macro to unprotect the sheet run spell check
and the protect the sheet, I am not sure but I think in later versions of
excel there might be a option for this when you protect the sheet

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"
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 97 & 2000
** remove news from my email address to reply by email **
 

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

using Spell check on protected sheet 6
Spell Check 5
How does a user spell check protected document in Excel? 6
No Spell Check 1
Protection Options Changes 2
Spell Checking an Excel Form 1
Spell Check with protected sheets 3
Spell-check problem 0

Top