Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Greetings. I found this code on the site yesterday (thanks to the poster). I
replaced "password" with the sheet protection actual password. I can get it to run from: Tools, Macro, Run (without unprotecting the sheet) but not from the shortcut key without unprotecting the sheet. Any suggestions? (i'm over the top, iv'e been fooling with it for an entire day). Please help. Thanks so much. Sub Spell_Check() ' Keyboard Shortcut: Ctrl+Shift+C ' ActiveSheet.Unprotect Password:="password" Cells.CheckSpelling SpellLang:=1033 ActiveSheet.Protect Password:="password", DrawingObjects:=True, _ Contents:=True, Scenarios:=True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I use the spell check on a protected sheet in Excel? | Excel Worksheet Functions | |||
Protected sheet spell check | Excel Discussion (Misc queries) | |||
Spell check in a protected sheet | Excel Discussion (Misc queries) | |||
Allow unprotected cells to spell check after sheet is protected | Excel Worksheet Functions | |||
spell check in an Excel protected sheet | Excel Discussion (Misc queries) |