Steve
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 Sun, 14 Nov 2004 00:53:01 -0800, "steve"
wrote:
Hello
I made up a sheet for workers to fill out and then I protected the cells I
don't want them to be able to change. but now with the sheet protected the
spell checker doesn't work. can it be set up to run on a protected work sheet
?
Thank You
|