Hi,
Is it possible to somehow detect that comment was deleted in a cell?
I'm currently using comments to put previous value of a cell, so that there would be history of what was before the change in the cell. To avoid users accidently deleting comments I'm using sheet protection (I don't allow editing objects, which protects comments too). So whenever user changes something in the cell the following actions in worksheet occur:
1. worksheet unprotects itself;
2. worksheet enters previous value into a comment;
3. worksheet protects itself.
However, users expressed the need to have shared Excel file. But whenever I enable sharing of the file, protecting/unprotecting of Excel file crashes - it's not possible to use protect/unprotect feature in shared Excel file.
So I'm wondering, if I avoid using protect/unprotect feature, is it possible to somehow detect that comment was deleted in a cell? Or maybe there's some other way to protect comments in shared excel file?
Regards,
Bookmarks