Workbook-Events don´t work with ChartObjects
 

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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/