Spell check with protected worksheet

T

Tsi Waipahu

Does anyone know how do setup that user can use spell check on the
unprotected range even with the protection is on?
 
F

Frank Kabel

Hi
not possible. You may create a macro (record one) which first
unprotects the worksheet, then runs the spell checker and protects the
sheet again
 
G

Gord Dibben

Such a macro could look like this.

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
 
Top