ExcelBanter - Prevent deletion Comments

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Prevent deletion Comments (https://www.excelbanter.com/excel-programming/340156-prevent-deletion-comments.html)

SIGE

Prevent deletion Comments

Hello again,

Is it possible to prevent deletion of "Comments" in a specified area?

eg. In range A1:B5 you cannot delete the Comments.

Any help is once again really appreciated!

Sige

Vacation's Over

Prevent deletion Comments

The only way i know would be to use the open/Save events to rewrite the cell
comments

"Sige" wrote:

Hello again,

Is it possible to prevent deletion of "Comments" in a specified area?

eg. In range A1:B5 you cannot delete the Comments.

Any help is once again really appreciated!

Sige

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