make menu visible when chart is activate

[bolcskei]

Hi to all,

I would like to ask you how is it possible to make menu or command button visible, when the chart in excel is activated?

Boris

[sciguyryan]

Well, I suppose you could do it this way:

Create a timer with an interval of 1000.

In that timer, check if the particular chart is active, if it is then show the menu, otherwise hide it.

I'm not shure that will work but its an idea for you to try

Cheers,

RyanJ

[bolcskei]

Well, I suppose you could do it this way:

Create a timer with an interval of 1000.

In that timer, check if the particular chart is active, if it is then show the menu, otherwise hide it.

I'm not shure that will work but its an idea for you to try

Cheers,

RyanJ

Exists any other method, because I am green in VB and do not have experience with timering?

Boris