| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to overide spell check blocking in protected sheet
The problem is that when a worksheet is password protected
(which is necessary), you cannot spell check. Can a macro be created to override this? Thanks so much for any help on this :) J.P. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to overide spell check blocking in protected sheet
A macro can unprotect the sheet, run the spell check, protect the sheet.
Turn on the macro recorder and perform the actions manually to get the code. -- Regards, Tom Ogilvy "johnnymo" wrote in message ... The problem is that when a worksheet is password protected (which is necessary), you cannot spell check. Can a macro be created to override this? Thanks so much for any help on this :) J.P. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to overide spell check blocking in protected sheet
Remember that the password will be in the generated macro
code. So it could be good to protect the code (Lock object from viewing), although this password could very easily be cracked.... -----Original Message----- A macro can unprotect the sheet, run the spell check, protect the sheet. Turn on the macro recorder and perform the actions manually to get the code. -- Regards, Tom Ogilvy "johnnymo" wrote in message ... The problem is that when a worksheet is password protected (which is necessary), you cannot spell check. Can a macro be created to override this? Thanks so much for any help on this :) J.P. . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to overide spell check blocking in protected sheet
DUH !!!?????
Thanks for taking the time for this. I feel sooooo ........ Thanks again,J.P. -----Original Message----- A macro can unprotect the sheet, run the spell check, protect the sheet. Turn on the macro recorder and perform the actions manually to get the code. -- Regards, Tom Ogilvy "johnnymo" wrote in message ... The problem is that when a worksheet is password protected (which is necessary), you cannot spell check. Can a macro be created to override this? Thanks so much for any help on this :) J.P. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using Spell check on protected sheet | Excel Worksheet Functions | |||
| spell check on protected sheet | Excel Discussion (Misc queries) | |||
| Spell check protected sheet | Excel Discussion (Misc queries) | |||
| Protected sheet spell check | Excel Discussion (Misc queries) | |||
| Spell check in a protected sheet | Excel Discussion (Misc queries) | |||
Linear Mode
