Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't open protected sheets | Setting up and Configuration of Excel | |||
Protected Sheets or other security | Excel Discussion (Misc queries) | |||
PROTECTING/UNPROTECTING SHEETS | Excel Discussion (Misc queries) | |||
Grouping in protected sheets | Excel Discussion (Misc queries) | |||
Multiple sheets selected | Excel Discussion (Misc queries) |