Protect Comments from deletion
Hi
I have set up a spreadsheet using the worksheet change command so that when
a user changes the data in a cell the font changes colour and a comment is
added to say who made the change and when. I don't want the users to be able
to delete the comment because I need to record it. Is there any way of doing
this. Worksheet protection is not an option in this case.
Any help would be gratefully received.
Thanks
Aehan
|