View Single Post
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

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