How can I use spell checking in a protected worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My worksheet is protected but in the cells that a user can enter data I would
like to have the spell checking available but the button is grayed out unless
I turn the protection off.
 
Deb

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 Mon, 24 Apr 2006 07:58:02 -0700, Deb from MA <Deb from
My worksheet is protected but in the cells that a user can enter data I would
like to have the spell checking available but the button is grayed out unless
I turn the protection off.
Click to expand...

Gord Dibben MS Excel MVP
 
Back
Top