| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check Spelling With Sheet Protected
How can I check spelling of unlocked cells when I have sheet protection on.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check Spelling With Sheet Protected
Using a macro is the only work around that I know of.
Sub Spell_Check() ActiveSheet.Unprotect Password:="justme" Cells.CheckSpelling SpellLang:=1033 ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _ Contents:=True, Scenarios:=True End Sub Unprotects the sheet, does the spellcheck then reprotects the sheet. "justme" can be changed to your password. Gord Dibben MS Excel MVP On Mon, 17 Mar 2008 18:35:00 -0700, Ghudak1969 wrote: How can I check spelling of unlocked cells when I have sheet protection on. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spell check protected sheet | Excel Discussion (Misc queries) | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
| Spell check in a protected sheet | Excel Discussion (Misc queries) | |||
| how do you check and edit spelling on a protected sheet. | Excel Discussion (Misc queries) | |||
| ... Can I set Spell Check to automatically check my spelling ... | Setting up and Configuration of Excel | |||
Hybrid Mode
