Spell check a protected spreadsheet

E

Emma

I have created a template spreadsheet and locked & protected some calc cells.
But the user now need to spell check the spreadsheet, but it is not
available while the spreadsheet is protected.

Is there any way this can be resolved, withouth unprotecting the sheet.

Thanks
Emma
 
G

Gord Dibben

Emma

You can use this macro to unprotect, run the spellcheck, then re-protect the
sheet.

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