mrMadCat
New Member
- Joined
- Jun 8, 2016
- Messages
- 39
- Office Version
- 365
- Platform
- Windows
- Mobile
- Web
Hello.
I need to run a macro that reacts on activity showing that user works with the workbook: selecting cells, refreshing pivots, changing formats, copy-pasting etc. I didn't find any universal function (if there is any please say). But I've found this to be quite suitable for me because most of activity with excel is based on selecting cells.
The problem is that I have to put this macro in some Worksheet but I want to make it work independently for any active worksheet in the workbook. What I need to solve this?
Sorry for may be dumb question, I am quite a casual VBA user.
Thank you.
I need to run a macro that reacts on activity showing that user works with the workbook: selecting cells, refreshing pivots, changing formats, copy-pasting etc. I didn't find any universal function (if there is any please say). But I've found this to be quite suitable for me because most of activity with excel is based on selecting cells.
Code:
Sub Worksheet_SelectionChange(ByVal Target As Range)
msgBox "Change"
End Sub
Sorry for may be dumb question, I am quite a casual VBA user.
Thank you.