Is there a way to spell check a protected sheet?

M

matt

I have created a form which has the users enter in a lot
of text in various parts of the workbook. Because there
are also several calculations going on in the background,
and to preserve formatting I would like to protect the
sheet.

When I try to spellcheck the sheet or the objects which
have text that is not locked, Excel informs me that I
cannot spell check a protected sheet.

Is there a workaround for this?

Thanks - Matt
 
D

Dave Peterson

Can you give the users a macro that unprotects, checks speling, then reprotects?
 

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

Top