Create a link to print a certain range

A

AdamCPTD

I have a spreadsheet that has two different reports on it.
I would like to have two different links at the top of the page that say
"Click here to Print Report 1" and "Click here to Print Report 2."
I have no idea how to do this, or if it is even possible.
Thanks for any help!

Adam
 
D

Dave Peterson

Record two macros.

Record the first when you print the first report. Record the second when you
print the second report.

Then show the Forms toolbar. Put a button from that toolbar on the worksheet.
Assign the first macro to that button. And change the caption to show what you
want.

And then do the same for the second button.
 
Top