Excel access control?

Hi I work on a network with everyone logging with unique usernames and passwords. I normally distribute work through work through password protected shared excel files. However i ned to create a macro to check who is accessing the file. When anyone access this excel file, i need excel to send me an email... show more Hi

I work on a network with everyone logging with unique usernames and passwords. I normally distribute work through work through password protected shared excel files.

However i ned to create a macro to check who is accessing the file. When anyone access this excel file, i need excel to send me an email saying the user "<username> has viewed your file".

OR, his username should be captured on an other excel file with time and his user name.
2 answers 2