Excel chart print from Dashboard

[elohelae]

Hello

I have an excel dashboard with 10 charts on it and I have now been asked to place a button on the chart which when clicked will print out all the charts on individual sheets.

What is the best method to go about this? Any good advice would be appreciated.

 

[SkipVought]

hi,

Turn on your macro recorder and record selecting and printing ONE CHART.

Copy your recorded code and post it, along with your original question in forum707, where you will get a better response than in this forum.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[elohelae]

appreciated, thank you