Spell Check function on a protected sheet

[Mark]

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

 

[ShaneDevenshire]

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.