View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.