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 - 19 Dec 2003 11:31 GMT
If only one chart is visible at any given time, it kinda restricts the
ability to select any chart. Or am I missing something?

Signature
Regards,
Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
> 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...
Jon Peltier - 19 Dec 2003 13:43 GMT
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
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______
> 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...