Triggers on chart

[#1]

Hi,

I have created trigger on chart. when I opened the chart other chart also automatically opens due to tigger thats fine

But when I do any selection other chart automatically minimizes which i dont want

Can anyone suggest regarding this?

[Anonymous]

Create macros to restore/minimize your 2 charts with code something like this:

Sub RestoreCharts
   set c=ActiveDocument.GetSheetObject("1stChartObjectIDhere")
   c.restore
end sub

Sub MinimizeCharts
   set c=ActiveDocument.GetSheetObject("1stChartObjectIDhere")
   c.minimize
end sub

hen from the Sheet->Properties->Macro page set SheetObjectEventTriggers to call your macros for OnActivate on the objects you want.