Audit Trail

[jenziepie]

I'd like to create a macro that makes an audit trail that will show on my sheet AuditTrail. It will track the changes made to the unprotected, cells that are available to change. I have already built a button and an onAction callback for the macro entitled AuditChanges. I do not need this to be private, as I would like it to be available to advanced users. How can I create this macro? Thank you!

[LJMetzger]

The attached file will probably do what you want with a small amount of modification. If you need help post a sample file and I can integrate my data log into your sample file.

You need a call to the Data Log Open routine at workbook startup. My version clears the log at each Workbook Open, if you want the log to go on forever, take out the call to the Clear routine.

You need a call to the Data Log Write routine at each change probably using a Worksheet_Change event.

You need to save the Worksheet before you exit Excel if you want the log to be perrmanent.

Good Luck.

Lewis