ExcelBanter - Comments on Protected Sheet

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Comments on Protected Sheet - Excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/227729-comments-protected-sheet-excel-2003-a.html)

SteveG[_3_]

Comments on Protected Sheet - Excel 2003

Is it possible to protect a worksheet but still allow people to insert
comments to cells. Even if the cell is unprotected, Excel still doesn't
allow comments to be inserted.

Mike H

Comments on Protected Sheet - Excel 2003

Hi,

When you protect the sheet check 'Edit Objects' and you can enter comments

Mike

"SteveG" wrote:

Is it possible to protect a worksheet but still allow people to insert
comments to cells. Even if the cell is unprotected, Excel still doesn't
allow comments to be inserted.

SteveG[_3_]

Comments on Protected Sheet - Excel 2003

Thanks!

"Mike H" wrote:

Hi,

When you protect the sheet check 'Edit Objects' and you can enter comments

Mike

"SteveG" wrote:

Is it possible to protect a worksheet but still allow people to insert
comments to cells. Even if the cell is unprotected, Excel still doesn't
allow comments to be inserted.

All times are GMT +1. The time now is 08:55 PM.