I would like to use VBA to perform two actions:
- insert a picture or a graph in a password protected worksheet.
- generating an audit trail, saved as a .txt file (date, username, type*, sheet name, cell reference, old value, new value)
* open, close, save, picture insertion, graph insertion, picture deletion,....
Every action I perform on the Excel file should be logged in this .txt.
The excel built-in track changes functionality is not sufficient since the audit trail is only limited to 30 days (and impossible to extend to 20 years) and does not keep track of picture/graph insertion or -deletion.
I am really a complete VBA nitwit, so preferentially I receive an .xlsm with the code embedded. Google has not been my friend so far to resolve my issue!
THANK YOU!!
Bookmarks