Protected sheets
 

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
--
steve

Hi
no you can't. The best you could do is for exampl:
- start recording a macro
- unprotect the sheet
- start the spell checker
- protect the sheet again

Now ue this recorded macro


--
Regards
Frank Kabel
Frankfurt, Germany


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

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