Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Protected Worksheets and Comments
Hi all, I would like to be able to be able to add comments to a protected worksheet. I am using Excel 2007 Beta. When I "protect" the sheet, I do the following... Yes = Select locked cells Yes = Select unlocked cells Yes = Edit Objects Once the sheet is protected, I am able to click on add-comment, but then I am told the sheet is protected and this is not allowed. Any ideas? Best Regards, Darrell |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Protected Worksheets and Comments
Not sure about 2007 but try deselecting the "objects" selection.
In Excel 2000 when you select Tools-Protection-Protect Sheet the menu looks like this... Protect worksheet for Contents Objects Scenarios By deselecting objects you are allowed to add, remove, and edit comments. I assume 2007 Beta should work the same in this case. "Darrell (Singapore)" wrote: Hi all, I would like to be able to be able to add comments to a protected worksheet. I am using Excel 2007 Beta. When I "protect" the sheet, I do the following... Yes = Select locked cells Yes = Select unlocked cells Yes = Edit Objects Once the sheet is protected, I am able to click on add-comment, but then I am told the sheet is protected and this is not allowed. Any ideas? Best Regards, Darrell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding comments into a protected worksheet | Excel Discussion (Misc queries) | |||
Inserting Comments in protected worksheets | Excel Discussion (Misc queries) | |||
COMMENTS ON PROTECTED WORKSHEETS | New Users to Excel | |||
Comments will not delete from Worksheet | Excel Discussion (Misc queries) |