possible to run a spell check on a protected spreadsheet?

  • Thread starter Thread starter Dan
  • Start date Start date
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
 
Hi
AFAIK you have to unprotect the sheet before starting the spellchecker
(even for unprotected cells)
 
Back
Top