using spellcheck while a worksheet is protected

G

Guest

I have locked and unlocked cells in my worksheet to create a fill in the blanks form. I have protected the worksheet and I would like my customers to be able to spell check. The spell check feature is not available if the worksheet is protected. How can I give this function back to the customer; before they print the form filled out?
 
P

Peo Sjoblom

You need to have a macro that unprotect the sheet, spell-check, protect and
then print it.

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom


Karla said:
I have locked and unlocked cells in my worksheet to create a fill in the
Click to expand...
blanks form. I have protected the worksheet and I would like my customers
to be able to spell check. The spell check feature is not available if the
worksheet is protected. How can I give this function back to the customer;
before they print the form filled out?
 

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
User controlled Freeze Pane while protected 3
Spell Check function on a protected sheet 1
protect worksheet but allow row deletion 3
How can I use spellcheck on a spreadsheet that is protected? 2
Formatting of cells in a locked worksheet. EG shading 1
Settiing up spellcheck in a protected Excel document 2
when I protect a worksheet, user cannot use check boxes 4

Top