ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   edit comments in locked cells (https://www.excelbanter.com/excel-worksheet-functions/94854-edit-comments-locked-cells.html)

bmnjna2019

edit comments in locked cells
 
I want to allow users the ability to edit existing comments to a locked
cell/protected worksheet. I have checked the 'edit object' in the protect
worksheet dialog box, however, every time someone tries to edit the comments,
the cursor jumps to an unlocked cell and adds a new comment there instead.
What is it that I'm doing wrong? Many thanks.


All times are GMT +1. The time now is 01:34 AM.

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