View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
aehan aehan is offline
external usenet poster
 
Posts: 17
Default 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