Spell Check in Protected Worksheets

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

Guest

I've read that the spell check function is not available in a protected
worksheet, but does anyone know of a work around?

Thanks in advance for you assistance.
 
Using a macro is the only work around that I know of.

Sub Spell_Check()
ActiveSheet.Unprotect Password:="justme"
Cells.CheckSpelling SpellLang:=1033
ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _
Contents:=True, Scenarios:=True
End Sub

Unprotects the sheet, does the spellcheck then reprotects the sheet.

"justme" can be changed to your password.


Gord Dibben MS Excel MVP
 
Thank you for the advice Gord. One question though, I have text boxes in my
form which your macro appears to ignore. Is there something I can change to
have spell check look at everything on the sheet?

Thanks again!
 

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

Enabling Spell Check in Protected Worksheet 2
Spelling checker problem on a specific worksheet only 1
spell check on protected sheet 2
Spell Check cells in Protected Worksheet? 1
Spell check in a protected sheet 1
How does a user spell check protected document in Excel? 6
Spell Check w/ Protection 3
Spell Check 5

Back
Top