Home |
Search |
Today's Posts |
#1
|
|||
|
|||
can you insert a comment into a protected worksheet?
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? |
#2
|
|||
|
|||
can you insert a comment into a protected worksheet?
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 -- Regards Ron de Bruin http://www.rondebruin.nl "TKGerdie" wrote in message ... 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? |
#3
|
|||
|
|||
can you insert a comment into a protected worksheet?
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. "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl "TKGerdie" wrote in message ... 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? |
#4
|
|||
|
|||
can you insert a comment into a protected worksheet?
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. "TKGerdie" wrote: 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. "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl "TKGerdie" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you shade in an unlocked cell on a protected worksheet? | Excel Discussion (Misc queries) | |||
Sorting on a protected worksheet | Excel Discussion (Misc queries) | |||
Protect Worksheet but allow to insert or delete rows | Excel Discussion (Misc queries) | |||
How do I show protected cells in an EXCEL worksheet | Excel Discussion (Misc queries) | |||
Insert worksheet | Excel Worksheet Functions |