Logic_Is_Fun
New Member
- Joined
- Feb 17, 2016
- Messages
- 3
I have an Excel workbook (5 worksheets) that I'm posting to a share drive for my colleagues. The purpose of the Excel workbook is to gather assumptions in an organized manner for a financial model that I'm developing.
For data quality check purposes, I would like to have a VBA code that states the following whenever a change is made to the Excel workbook:
1) User name of who made the change;
2) Date & time the change was made;
3) Name of worksheet that was edited.
These 3 items will show on a 6th worksheet.
I'm a simple person, who likes simple code.![Wink ;) ;)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Thank you in advance!!!
For data quality check purposes, I would like to have a VBA code that states the following whenever a change is made to the Excel workbook:
1) User name of who made the change;
2) Date & time the change was made;
3) Name of worksheet that was edited.
These 3 items will show on a 6th worksheet.
I'm a simple person, who likes simple code.
Thank you in advance!!!