| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spell Check cells in Protected Worksheet?
Is it possible to run the spelling checker on a worksheet when the worksheet
is protected? It doesn't appear that it is possible through Excel's "normal" options. A customer has created a protected Excel form with certain cells unlocked for data. If the person misspells data in these cells, the spelling checker is not available. Any way around this? Any suggestions would be appreciated! Thanks. Jugglertwo |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Spell Check cells in Protected Worksheet?
You can use this macro to unprotect, run the spellcheck, then re-protect the
sheet. 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 Thu, 27 Jul 2006 11:17:02 -0700, Jugglertwo wrote: Is it possible to run the spelling checker on a worksheet when the worksheet is protected? It doesn't appear that it is possible through Excel's "normal" options. A customer has created a protected Excel form with certain cells unlocked for data. If the person misspells data in these cells, the spelling checker is not available. Any way around this? Any suggestions would be appreciated! Thanks. Jugglertwo Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protected sheet spell check | Excel Discussion (Misc queries) | |||
| How can I have a protected worksheet and have spell check ability | Excel Discussion (Misc queries) | |||
| Spell Check in Protected Worksheet & Shared Workbook | Excel Discussion (Misc queries) | |||
| Problem trying to move between cells on a protected worksheet. | Excel Discussion (Misc queries) | |||
| spell check protected document | Excel Discussion (Misc queries) | |||
Linear Mode
