My macro needs to know when the user changes sheet.
I have located the Workbook_SheetActivate event but I'm confused as where I
place this.
If I place it in a code module in my macro it does not get executed.
If I place it in ThisWorkBook of my macro it does get executed when I change
Chris, first can you explain what you want to achieve with the sheet change
event. We can then decide on what kind of event and the level of the event
required. For example, if you just want to know whether the users switched
from your workbook to another workbook, you don't need a sheet event,