Print Chart Idea Needed

[Phil Hageman]

I have a number of charts "stacked" one over the other -
the user can only see one at a time (done by VBA). Now I
want to put a feature on the worksheet where the user can
select a chart and print it. Need ideas...

 

[Tushar Mehta]

If only one chart is visible at any given time, it kinda restricts the
ability to select any chart. Or am I missing something?

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

Phil -

How does the user (or the program) select the chart to view? The same
approach could be used to send the appropriate chart to the printer.

- Jon