| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a link to print a certain range
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create a link to print a certain range
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. AdamCPTD wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| range in link? | Excel Discussion (Misc queries) | |||
| How do I link one cell to a range of cell with a drop-down menu? | Excel Discussion (Misc queries) | |||
| Macro to set print range | New Users to Excel | |||
| Using a formula to create named range reference | Excel Worksheet Functions | |||
Hybrid Mode
