How can I use spell checking in a protected worksheet?

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.
 
G

Gord Dibben

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.

Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top