View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jacques Brun Jacques Brun is offline
external usenet poster
 
Posts: 7
Default 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.



.