ExcelBanter - Put comments on a locked spreadsheet even though cells not locked

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Put comments on a locked spreadsheet even though cells not locked (https://www.excelbanter.com/excel-worksheet-functions/44842-put-comments-locked-spreadsheet-even-though-cells-not-locked.html)

RDP

Put comments on a locked spreadsheet even though cells not locked

How do I add "Comments" to a protected work sheet. The cells I am trying to
add comments to are not locked but I still can't add commetns.

Debra Dalgleish

When you protect the worksheet, allow users to edit objects, and you'll
be able to add comments to the worksheet.

RDP wrote:
How do I add "Comments" to a protected work sheet. The cells I am trying to
add comments to are not locked but I still can't add commetns.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

All times are GMT +1. The time now is 09:31 PM.