How can I have a protected worksheet and have spell check ability

[Moe Green]

I have a worksheet that is used as a form that several people enter data into
and they would like to be able to spellcheck what they enter into the
unprotected cells.

I have certain cells unlocked then I protected the worksheet, only enabling
"Selecting of Unlocked Cells" in the protect sheet options. However, the
Spellcheck functionality is no longer able to be used in the spreadsheet once
it's protected.

Is there an option that will protect the worksheet and still allow
spellcheck of the unlocked cells?

 

[Gord Dibben]

Moe

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, 30 Mar 2006 11:52:01 -0800, Moe Green <Moe

I have a worksheet that is used as a form that several people enter data into
and they would like to be able to spellcheck what they enter into the
unprotected cells.

I have certain cells unlocked then I protected the worksheet, only enabling
"Selecting of Unlocked Cells" in the protect sheet options. However, the
Spellcheck functionality is no longer able to be used in the spreadsheet once
it's protected.

Is there an option that will protect the worksheet and still allow
spellcheck of the unlocked cells?

Gord Dibben MS Excel MVP