Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I use spell checking in a protected worksheet?
My worksheet is protected but in the cells that a user can enter data I would
like to have the spell checking available but the button is grayed out unless I turn the protection off. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I use spell checking in a protected worksheet?
Deb
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 Mon, 24 Apr 2006 07:58:02 -0700, Deb from MA <Deb from wrote: My worksheet is protected but in the cells that a user can enter data I would like to have the spell checking available but the button is grayed out unless I turn the protection off. Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I unprotect a text box in an otherwise protected worksheet | Excel Discussion (Misc queries) | |||
Run macros on protected worksheet | Excel Worksheet Functions | |||
Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
Question about sorting in protected worksheet | Excel Worksheet Functions | |||
How use group and ungroup functions while worksheet is protected | Excel Worksheet Functions |