Spellchecking a protected document in Excel
 

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?

Spellchecking a protected document in Excel
 

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

On Thu, 5 Mar 2009 12:13:01 -0800, BeerHR
wrote:

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?