software

I am creating a form. I have locked certain cells, while others are
unlocked. The unlocked cells will be used to fill out the form. I would
like the user to be able to use spellcheck. I have tried to use the 'Allow
Users to Edit Ranges' under Protection by including all unlocked cells, but
spellcheck is still locked out for the entire document as soon as I put in
the password. Is there a way to do this?

teejay

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 Thu, 27 Apr 2006 08:24:01 -0700, teejay gt;
wrote:

gt;I am creating a form. I have locked certain cells, while others are
gt;unlocked. The unlocked cells will be used to fill out the form. I would
gt;like the user to be able to use spellcheck. I have tried to use the 'Allow
gt;Users to Edit Ranges' under Protection by including all unlocked cells, but
gt;spellcheck is still locked out for the entire document as soon as I put in
gt;the password. Is there a way to do this?

Gord Dibben MS Excel MVP

Gord
Sorry I didnt reply right away. The macro worked fine after I changed the
security. I am surprised that spellcheck is not made available when you
protect the sheet. Thanks so much for your help.

teejay

quot;Gord Dibbenquot; wrote:

gt; teejay
gt;
gt; You can use this macro to unprotect, run the spellcheck, then re-protect the
gt; sheet.
gt;
gt;
gt; Sub Spell_Check()
gt; ActiveSheet.Unprotect Password:=quot;justmequot;
gt; Cells.CheckSpelling SpellLang:=1033
gt; ActiveSheet.Protect Password:=quot;justmequot;, DrawingObjects:=True, _
gt; Contents:=True, Scenarios:=True
gt; End Sub
gt;
gt;
gt; Gord Dibben Excel MVP
gt;
gt; On Thu, 27 Apr 2006 08:24:01 -0700, teejay gt;
gt; wrote:
gt;
gt; gt;I am creating a form. I have locked certain cells, while others are
gt; gt;unlocked. The unlocked cells will be used to fill out the form. I would
gt; gt;like the user to be able to use spellcheck. I have tried to use the 'Allow
gt; gt;Users to Edit Ranges' under Protection by including all unlocked cells, but
gt; gt;spellcheck is still locked out for the entire document as soon as I put in
gt; gt;the password. Is there a way to do this?
gt;
gt; Gord Dibben MS Excel MVP
gt;