keilah
03-30-2008, 03:32 AM
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
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