Spell Check function on a protected sheet

G

Guest

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.
 

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

using Spell check on protected sheet 6
Spell check 2
spell check on protected sheet 2
spell checking options 2
Enabling Spell Check in Protected Worksheet 2
Spell Check in Protected Work Book 2
Spell check and protected worksheet 2
Spell Checking on a protected sheet 1

Top