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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spelling checker problem on a specific worksheet only 1
Spell Check with protected sheets 3
Spell Check 5
Spell Check cells in Protected Worksheet? 1
Check Spelling With Sheet Protected 1
Spell Check Unlocked Cells Only 9
How does a user spell check protected document in Excel? 6
Spell check and protection 1

Back
Top