Protected sheets

[steve]

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

 

[Frank Kabel]

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

 

[Gord Dibben]

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