spell check in an Excel protected sheet

Office 2003 - Excel
I am trying to make it possible for personnel to spell check information
they insert, in a unlocked cell in a password protected worksheet. I have
tried everything I can find in all HELP areas, but cannot find anything

Cats

Requires VBA to unprotect the sheet, do the spellcheck then reprotect the
sheet.

Similar to.......

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 Wed, 16 Feb 2005 11:05:06 -0800, "Cats" <Cats@discussions.microsoft.com>
wrote:

>Office 2003 - Excel
>I am trying to make it possible for personnel to spell check information
>they insert, in a unlocked cell in a password protected worksheet. I have
>tried everything I can find in all HELP areas, but cannot find anything