ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Allowing comments in unlocked cells within protected sheet (https://www.excelbanter.com/excel-discussion-misc-queries/129489-allowing-comments-unlocked-cells-within-protected-sheet.html)

Suz

Allowing comments in unlocked cells within protected sheet
 
Using Excel 2003, I have a workbook with many sheets. I have protected both
the workbook and ranges of cells in the worksheet. In those cells which
remain unlocked, I am still not able to add "comments" to the cells. Is there
any way around this?
thx
Susanne

Mike

Allowing comments in unlocked cells within protected sheet
 
When you protect the sheet allow users to edit objects by inserting the
checkmark

"suz" wrote:

Using Excel 2003, I have a workbook with many sheets. I have protected both
the workbook and ranges of cells in the worksheet. In those cells which
remain unlocked, I am still not able to add "comments" to the cells. Is there
any way around this?
thx
Susanne



All times are GMT +1. The time now is 05:54 AM.

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