spell check in an Excel protected sheet

C

Cats

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
 
G

Gord Dibben

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
 
Top