G
geissma
I have some problems with Excel-ChartObjects and Workbook-Events. When I
try to switch between 2 different workbooks the events
Workbook_Activate and Workbook_Deactivate are not executed when a
(embedded) ChartObject is selected. When I deselect the Chart by
clicking into any cell the events work.
I am working with Excel2000 but I tested this with Excel2002 as well
and had the same problems.
I tested this with 2 simple workbooks (Book1 with chart, book2 without
chart) and just MessageBoxes in the Activate/Deactivate-Events to see
wether my code is the reason for this behavior. But as well when the
chart is not selected and I switch Books, all 4 MsgBoxes appear. When
the chart is active and I switch from Book2 to Book1 everthing works,
but form Book1 to Book2 no MsgBox appears.
Can anybody help me with this?
Thank you
Martin
try to switch between 2 different workbooks the events
Workbook_Activate and Workbook_Deactivate are not executed when a
(embedded) ChartObject is selected. When I deselect the Chart by
clicking into any cell the events work.
I am working with Excel2000 but I tested this with Excel2002 as well
and had the same problems.
I tested this with 2 simple workbooks (Book1 with chart, book2 without
chart) and just MessageBoxes in the Activate/Deactivate-Events to see
wether my code is the reason for this behavior. But as well when the
chart is not selected and I switch Books, all 4 MsgBoxes appear. When
the chart is active and I switch from Book2 to Book1 everthing works,
but form Book1 to Book2 no MsgBox appears.
Can anybody help me with this?
Thank you
Martin