ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Comments (https://www.excelbanter.com/excel-worksheet-functions/253140-comments.html)

LPhillips

Comments
 
Can you tell me how to add comments to an individual cell when the worksheet
is protected? The option does not appear on the toolbar nor when right
clicking.

Pierre

Comments
 
On Jan 12, 12:43*pm, LPhillips
wrote:
Can you tell me how to add comments to an individual cell when the worksheet
is protected? The option does not appear on the toolbar nor when right
clicking.


This might help you.
from:
http://www.mrexcel.com/forum/showthread.php?t=63962

"In other versions, if you protect the sheet, but uncheck the objects
box, this will allow for comments to be inserted"

Let us know the results.


Pierre

Gord Dibben

Comments
 
ToolsProtectionProtect SheetAllow users to:

Make sure "Edit Objects" is checkmarked.


Gord Dibben MS Excel MVP

On Tue, 12 Jan 2010 10:43:01 -0800, LPhillips
wrote:

Can you tell me how to add comments to an individual cell when the worksheet
is protected? The option does not appear on the toolbar nor when right
clicking.




All times are GMT +1. The time now is 08:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com