Spell check and protection

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

Guest

I know that you're not able to use spell check in a protected sheet/workbook.
However, I need to create a sheet that allows users (non excel proficient) to
check spelling and at the same time not being able to change any locked
cells. Is there another way around this so that I can protect certain fields
without turning off the spell check feature.

Thanks
 
Mici, you could assign this macro to a button on the sheet, it will
unprotect the sheet, spell check, and then protect the sheet back

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
 

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

How does a user spell check protected document in Excel? 6
Spelling checker problem on a specific worksheet only 1
Enabling Spell Check in Protected Worksheet 2
Spell Check Protect Reprotect with same settings 1
Check Spelling With Sheet Protected 1
spell check on protected sheet 2
Spell Check with protected sheets 3
Spell Check on Excel document 2

Back
Top