Spellchecking a protected document in Excel

B

BeerHR

When I protect a sheet in Excel (the sheet has cells that can be filled in -
it's a form), I can't spellcheck the live cells. Help?
 
G

Gord Dibben

Note: not yet tested for Excel 2007

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
 
Top