Auto run an Environ Macro to see who uses my spreadsheet

[kaplanj23]

My boss is really interested in which of the sales managers are actually using, as well as how often, the new quarterly workbook I send out. I added code I found online that would email me anytime the workbook was opened with the environ username, but with the administrator settings on our VPN it brings up alerts that the email is being sent and allows you to deny the email.

Is there a code I could auto run when the workbook opens that will add the username of who opened, along with a timestamp of when, in a hidden tab?

[kev_]

Your boss sounds like Big Brother.
I hope you are planning to tell the sales managers that they are being monitored.
I would simply ask my staff the question and ask for honest answers.

Create a sheet called "Spy" and here's your code


in General module:

Please Login or Register  to view this content.

In ThisWorkbook module

Please Login or Register  to view this content.