Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protected Sheets
Hi, I have protected certian cells in my sheet. The sheet that I have protected is a shared attendance sheet where people can insert comments, and numbers. Since I have protected my sheet we can insert numbers, but we can't insert any comments. How can I leave certian cells protected and give others the right to insert these comments? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protected Sheets
When you protect the sheet (Tools Protection Protect sheet), you are
presented with a list of options, with a checkbox by each one. If "Edit objects" is checked, users will be able to insert comments in protected cells. Hope this helps, Hutch "Jeanne724" wrote: Hi, I have protected certian cells in my sheet. The sheet that I have protected is a shared attendance sheet where people can insert comments, and numbers. Since I have protected my sheet we can insert numbers, but we can't insert any comments. How can I leave certian cells protected and give others the right to insert these comments? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protected Sheets
In versions 2002 and 2003 you can Protect the sheet and allow users to "select
unlocked cells" and "Edit Objects". De-select allow users to "select locked cells". This will allow inserting comments in unlocked cells. Gord Dibben MS Excel MVP On Tue, 18 Mar 2008 09:41:03 -0700, Jeanne724 wrote: Hi, I have protected certian cells in my sheet. The sheet that I have protected is a shared attendance sheet where people can insert comments, and numbers. Since I have protected my sheet we can insert numbers, but we can't insert any comments. How can I leave certian cells protected and give others the right to insert these comments? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
protected sheets | Excel Worksheet Functions | |||
protected sheets | Excel Discussion (Misc queries) | |||
Protected Sheets | Excel Discussion (Misc queries) | |||
Protected sheets | Excel Worksheet Functions | |||
Protected sheets | Excel Worksheet Functions |