ExcelBanter - Is there a way to enter a comment on a locked cell in Excel?

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

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

- - Is there a way to enter a comment on a locked cell in Excel? (https://www.excelbanter.com/excel-worksheet-functions/182550-there-way-enter-comment-locked-cell-excel.html)

Is there a way to enter a comment on a locked cell in Excel?

I am trying to add a comment to a locked cell. I want to keep the cell
locked. Is there a way to enter a comment without unlocking it?

ryguy7272

Is there a way to enter a comment on a locked cell in Excel?

If you protect the sheet, but un-check the objects box, you can allow users
to add comments and still ensure that the sheet is protected from other types
of changes.

Regards,
Ryan---

--
RyGuy

"BJ" wrote:

I am trying to add a comment to a locked cell. I want to keep the cell
locked. Is there a way to enter a comment without unlocking it?

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