| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How does a user spell check protected document in Excel?
Thanks just the same - thanks for trying to help
"Gord Dibben" wrote: I don't use 2007 so can't help you there. All a mysteryg? Gord On Thu, 9 Oct 2008 14:11:01 -0700, Mary wrote: Gord, When I click the button I receive the following error message: "The macros in this project are disabled. Please refer to the online help or documentation of the host applicatoin to determine how to enable macros." I'm using Excel 2007 and have selected Enable all macros (although not recommended) and have checked the box to trust acces to the VBA prject object model. Any other recommendations will be appreciated. Thanks, Mary "Gord Dibben" wrote: 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. Note: code is for versions 2002 and 2003. The 1033 may be different in 2007 Gord Dibben MS Excel MVP On Thu, 9 Oct 2008 11:24:15 -0700, Mary wrote: I created an Excel template that is protected. The users are able to enter data in the unlocked sells but can not spell check their work. Is there a way for a user to check spelling without taking off the protection? Mary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use the spell check on a protected sheet in Excel? | Excel Worksheet Functions | |||
| Spell check a protected spreadsheet | Excel Discussion (Misc queries) | |||
| spell check for protected worksheet for Excel 97 | Excel Discussion (Misc queries) | |||
| spell check in an Excel protected sheet | Excel Discussion (Misc queries) | |||
| spell check protected document | Excel Discussion (Misc queries) | |||
Hybrid Mode
