make menu visible when chart is activate

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

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

Quote:

---

Originally Posted by 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

---

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

Boris