How to show a list box depending if a chart is active
Hi,
now that the triggers for sheet objects have been removed from QV11, is there any way to show object depending on if a chart is active? I wouldn't want to use any buttons, just to trigger an event based on if chart active or not. Could this be done with a macro?
I'm sure the Macro code is easy enough, using an IsActive method. The question would be how to trigger the macro. You could have a thread that loops in the background continuously, but this will have a performance impact.
