Spell Check w/ Protection

[Peter]

Does anyone know how you can enable spell checking for a protected worksheet?

 

[Frank Kabel]

Hi
you can't. You may record a macro which first unprotects the sheet, executes
spell checking and protects the sheet again

 

[Peter]

Thank You. Excellent suggestion that I think will do the job. Have a Happy
New Year.

 

[Gord Dibben]

Requires VBA to unprotect the sheet, do the spellcheck then reprotect the
sheet.

Similar to.......

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

Gord Dibben Excel MVP