 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2006Protected 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 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. > Hi all, > [quoted text clipped - 16 lines] > > Darrell |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.