software

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:=quot;justmequot;
Cells.CheckSpelling SpellLang:=1033
ActiveSheet.Protect Password:=quot;justmequot;, DrawingObjects:=True, _
Contents:=True, Scenarios:=True
End SubGord Dibben Excel MVP

On Mon, 24 Apr 2006 07:58:02 -0700, Deb from MA lt;Deb from
gt; wrote:

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

Gord Dibben MS Excel MVP