View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Spell Check function on a protected sheet

Hi Mark,

You can't spell check a protected sheet. What do you want to do if there is
a spelling error? If the sheet is protected then you couldn't change the
contents of the cells, that is the whole idea behind protectiong. You can
turn protection off, spell check the sheet and then turn protection on. You
could write a VBA program to format the cells that spell check finds.
--
Cheers,
Shane Devenshire


"Mark" wrote:

How can I enable the spell check button on a protected worksheet
--
Mark