I would like to have VB script added to the attached worksheet that will allow me to automatically track by running a consistent audit trail log on the second spreadsheet of all changes made to the first spreadsheet.
I would like the following tracked.
Date and time of the addition/change/deletions
The username (as stated in the Excel options tab)
An explanation of the additions/changes/deletion
Also, I would like to know can the cells on the audit log be locked by a password, so other users of the spreadsheet will not be able to manually change any of the information?
Looking forward to your responses. Thank you so much -- Chris