Spell Check cells in Protected Worksheet?
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
On Thu, 27 Jul 2006 11:17:02 -0700, Jugglertwo
wrote:
Is it possible to run the spelling checker on a worksheet when the worksheet
is protected?
It doesn't appear that it is possible through Excel's "normal" options.
A customer has created a protected Excel form with certain cells unlocked
for data. If the person misspells data in these cells, the spelling checker
is not available.
Any way around this?
Any suggestions would be appreciated!
Thanks.
Jugglertwo
Gord Dibben MS Excel MVP
|