If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Setting up protected document that can insert picture (photo ID template) | Craig | Page Layout | 5 | July 13th, 2007 01:15 PM |
Insert comment in protected worksheet | The Tuner | Worksheet Functions | 2 | June 6th, 2005 11:38 PM |
Import/Export XML in protected worksheet | jgentillet | General Discussion | 0 | May 13th, 2005 05:42 PM |
cannot insert a COMMENT into an ENDNOTE | Vision IPD | General Discussion | 1 | September 24th, 2004 02:43 AM |
Refresh data in Protected worksheet | Kevin T | General Discussion | 3 | July 15th, 2004 09:51 AM |