ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I create a comment on an unlocked cell in a protected sheet (https://www.excelbanter.com/excel-discussion-misc-queries/101118-how-do-i-create-comment-unlocked-cell-protected-sheet.html)

LObeidat

How do I create a comment on an unlocked cell in a protected sheet
 
Am not able to create a comment on an unlocked cell in a protected sheet.
Creating comments is not one of the features I can enable when protecting the
sheet. Please advise if you've faced/solved this problem before.

Dave Peterson

How do I create a comment on an unlocked cell in a protected sheet
 
Unprotect your worksheet
tools|protection|protect sheet

You'll see an object to allow the user to edit Objects (phrasing/location
changes with versions of excel). Make sure you allow this.

and continue with the protection.

Remember that when you allow comments, you're also allowing the users to change
other objects, too--shapes/buttons/pictures....

LObeidat wrote:

Am not able to create a comment on an unlocked cell in a protected sheet.
Creating comments is not one of the features I can enable when protecting the
sheet. Please advise if you've faced/solved this problem before.


--

Dave Peterson


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

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