ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Adding comments to unprotected cell in a protected sheet (https://www.excelbanter.com/excel-discussion-misc-queries/70398-adding-comments-unprotected-cell-protected-sheet.html)

Dave

Adding comments to unprotected cell in a protected sheet
 
Is there a way to add comments to an unprotected cell in a protected
worksheet? The option to insert a comment is not available in the insert
menu even when the cursor is on the unprotected cell.

Thanks
Dave

Dave Peterson

Adding comments to unprotected cell in a protected sheet
 
If you allow objects to be edited, you can add them.

But maybe that's too much to allow?

Dave wrote:

Is there a way to add comments to an unprotected cell in a protected
worksheet? The option to insert a comment is not available in the insert
menu even when the cursor is on the unprotected cell.

Thanks
Dave


--

Dave Peterson

Dave

Adding comments to unprotected cell in a protected sheet
 
Thank you that works.

What else will this allow the user to edit on the protected sheet? I am not
sure what is included under "Objects".

Thanks
Dave

"Dave Peterson" wrote:

If you allow objects to be edited, you can add them.

But maybe that's too much to allow?

Dave wrote:

Is there a way to add comments to an unprotected cell in a protected
worksheet? The option to insert a comment is not available in the insert
menu even when the cursor is on the unprotected cell.

Thanks
Dave


--

Dave Peterson


Dave Peterson

Adding comments to unprotected cell in a protected sheet
 
shapes, pictures, controls, ...

Dave wrote:

Thank you that works.

What else will this allow the user to edit on the protected sheet? I am not
sure what is included under "Objects".

Thanks
Dave

"Dave Peterson" wrote:

If you allow objects to be edited, you can add them.

But maybe that's too much to allow?

Dave wrote:

Is there a way to add comments to an unprotected cell in a protected
worksheet? The option to insert a comment is not available in the insert
menu even when the cursor is on the unprotected cell.

Thanks
Dave


--

Dave Peterson


--

Dave Peterson


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

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