Using a macro is the only work around that I know of.

Sub Spell_Check()
ActiveSheet.Unprotect Password:="justme"
Cells.CheckSpelling SpellLang:=1033
ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _
Contents:=True, Scenarios:=True
End Sub

Unprotects the sheet, does the spellcheck then reprotects the sheet.

"justme" can be changed to your password.


Gord Dibben MS Excel MVP


On Tue, 7 Aug 2007 15:18:03 -0700, jfitzpat
wrote:

I have a spreadsheet where I want to lock certain cells with formulas. On
the cells that users enter they want to use spellchecker. If I lock the
cells and spreadsheet, then Spellchecker is not available to use -- is there
a way to Lock and Spellcheck?

thanks Joyce