![]() |
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. |
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