| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spellchecking a protected document in Excel
When I protect a sheet in Excel (the sheet has cells that can be filled in -
it's a form), I can't spellcheck the live cells. Help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Spellchecking a protected document in Excel
Note: not yet tested for Excel 2007
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 Thu, 5 Mar 2009 12:13:01 -0800, BeerHR wrote: When I protect a sheet in Excel (the sheet has cells that can be filled in - it's a form), I can't spellcheck the live cells. Help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How does a user spell check protected document in Excel? | Excel Discussion (Misc queries) | |||
| Settiing up spellcheck in a protected Excel document | Excel Worksheet Functions | |||
| Opening Protected XL Document | Excel Discussion (Misc queries) | |||
| Help !!! Deleting rows in protected document ?!? | Excel Discussion (Misc queries) | |||
| Linking to a Password Protected Document in Excel 2000 | Excel Discussion (Misc queries) | |||
Hybrid Mode
