possible to run a spell check on a protected spreadsheet?

D

Dan

I have noticed that if a sheet is locked, it is no longer possible to run
the spell checker. Is there a way to run the spell checker through a macro
or only on unlocked cells while the sheet is protected? I know another
option is to run a macro that unlocks the sheet, runs a spell check on
certain cells, then re-lock it, but I would like to avoid that if possible.

any help is appreciated!
thanks, dan
 
F

Frank Kabel

Hi
AFAIK you have to unprotect the sheet before starting the spellchecker
(even for unprotected cells)
 
Top