can you insert a comment into a protected worksheet?

G

Guest

I am trying to protect formulas in a schedule tracking worksheet I've
created. There are columns that I have locked and other columns that the
users need to be able to enter dates, insert comments and highlight with
their colors. But when I protect the sheet, it won't allow them to insert a
comment. Is there any way to do this?
 
R

Ron de Bruin

Hi TKGerdie

If you use Excel 2002 or 2003 you have a option when you protect your sheet

Look for Edit Objects in the list
 
G

Guest

I check Edit Objects when I was protecting sheet, but now it allows them to
delete the formulas from the locked cells. This is bad. It was the whole
reason I was protecting the worksheet.
 
G

Guest

I figured it out. You have to also, unselect the option on the protect to
allow users to Select Locked Cells. Now it works. It keeps them out of my
formula cells.
 

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

How do you insert & delete rows in a protected worksheet? 1
Insert/ delete row in protected worksheet 7
Add comment in protected worksheet 3
Insert comment in protected worksheet 2
Insert row with a locked cell 1
Text from a comment box into a cell 3
Inserting comment in unlocked cell of protected Excel worksheet? 1
Auto insert a comment box. 1

Top