View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default Log specific changes

I have code in a workbook_BeforeSave event that Appends a txt file with an
entry that stamps user & date/time when the file is saved. I would like to
log any specific cells that are changed. The workbook has many worksheets and
I can conditionally choose the time period that I want to track the changes.
If cell $C$5 on sheet3 is changed, I want to log this and any other sheets
that are changed.

Thanks,

Sam