We all store Excel workbooks on shared drives. While those files are accessed by many users but there is no track about who did what at various points of time. However this problem can be resolved with the help of VBA. A VBA programme with following capability can help us to get the log of user activity.
- The Record Macro option on the Developer tab changes to Stop Recording. Perform the actions you want to record. Excel records your steps exactly — such as (Select cell C3) — but you can also record the steps relative to any current cell — such as (Go up one row and insert a blank line).
- Click the Begin Recording button, or choose Start Recording from the Actions panel menu. Record the additional commands. When finished, click the Stop Playing/Recording button in the Actions panel or choose Stop Recording from the panel menu. Rearrange commands within an action.
Following code has all these capabilities. Macro given below records user activity based on event information passed to it by another macro. You will need to copy this code to regular VBA module of your workbook
Master User Record
Following macros record events like 'Open' , 'Save' and 'Print'and pass on the information to above macro to record user activity.You will need to copy this code to worksheet module of your workbook
|
Following code has all these capabilities. Macro given below records user activity based on event information passed to it by another macro. You will need to copy this code to regular VBA module of your workbook
Master User Record
Following macros record events like 'Open' , 'Save' and 'Print'and pass on the information to above macro to record user activity.You will need to copy this code to worksheet module of your workbook
|
User Action Control
Excel new version 2017. Mouse actions can be recorded and played using hotkeys, which are set to F9 and F11 for record and playback modes respectively. Docker desktop size. Furthermore, you can loop the action by marking the ‘Repeat' option and specifying the time interval between successive repeats in seconds or minutes.
