When working on a protected sheet that has some cells locked and others unlocked. Is there a way to Spell Check text in the unlocked cells?
Thank you.
When working on a protected sheet that has some cells locked and others unlocked. Is there a way to Spell Check text in the unlocked cells?
Thank you.
Spell check is disabled on protected sheets, regardless of whether there are unlocked cells. The only way to do this is a custom VBA solution which will temporarily unprotect the sheet, do the spellcheck on unlocked cells, and re-protect the sheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks