Hi Experts

I have no idea how to do the following -

Need a macro that monitors who has logged into any particular workbook and amended any worksheet in that workbook. All the work books will be located in the folder in a common shared drive.

The macro need to record and enter the following information in a stand alone workbook/worksheet under the following heading:

User ID or Computer Name | WorkBook/Sheet Opened | Date | Time Opened | Time Closed | etc.....

Need to monitor the activities of the end users. If there is a much better or efficient way to do this all ideas welcome.

thanks