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