how do you check and edit spelling on a protected sheet.

G

Guest

I am not able to edit or check spelling on my protected(but unlocked cells)
sheet. How can I do that without unprotecting the sheets?
 
D

David McRitchie

Hi Fredonia,
If unprotecting a worksheet within a macro is out of the question then
copy the sheet to another page or application and spell check it there.
 

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

Check Spelling With Sheet Protected 1
Edit/Fill/Series on Protected Sheet 1
How does a user spell check protected document in Excel? 6
Inserting a comment box in a protected worksheet 2
How copy/paste values in Excel doc protected sheet 2 other doc? 4
Protecting certain cells only & Spell check 3
Spell Check with protected sheets 3
Protected Worksheet Tab Order 1

Top