This is part of a code I'm working on. For some reason I don't understand yet, the class activate event never fires. Someone who can tell me why?
(note: the attached WB only has a few lines of code)
Class Activate event does not fire
-
- BronzeLounger
- Posts: 1258
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
Class Activate event does not fire
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Class Activate event does not fire
Your code sets clsEventChart.EvtChart to the ActiveChart in the Workbook_SheetActivate event. In other words, the chart had been activated before you set clsEventChart.EvtChart. The Activate event of clsEventChart.EvtChart never fires because of that.
Best wishes,
Hans
Hans
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Class Activate event does not fire
Here is an alternative:
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1258
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
Re: Class Activate event does not fire
Clear. Thank you