Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What is the simplest way to print multiple worksheets?
I have a workbook with 30 worksheets of charts and 40 worksheets of data that
feed the charts. Now I like to find the easiest way to print all 30 charts from this workbook at one simple command without printing the 40 data worksheets. Yes, I know I can click all the tabs while holding down the Ctrl key and then print. But I still have to click 30 tabs!!! Is it possible to set the print area across the 30 worksheets that contain the charts? By the way, the print set up for each chart is exactly the same. Any help will be very much appreciated. |
#2
|
|||
|
|||
If your charts are all on CHART sheets instead of inbedded this should do it
Sub PrintOnlyChartSheets() Dim ch As Chart For Each sh In ActiveWorkbook.Charts sh.PrintOut ' or printpreview Next End Sub -- Don Guillett SalesAid Software "substring" wrote in message ... I have a workbook with 30 worksheets of charts and 40 worksheets of data that feed the charts. Now I like to find the easiest way to print all 30 charts from this workbook at one simple command without printing the 40 data worksheets. Yes, I know I can click all the tabs while holding down the Ctrl key and then print. But I still have to click 30 tabs!!! Is it possible to set the print area across the 30 worksheets that contain the charts? By the way, the print set up for each chart is exactly the same. Any help will be very much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
How do I print the same sheet multiple times with increasing page. | Excel Discussion (Misc queries) | |||
In Excel, how can I print a long list on 1 page in multiple colum. | Excel Discussion (Misc queries) | |||
set the print area print multiple tabs | Excel Discussion (Misc queries) | |||
Multiple Worksheets and Print Merge function | Excel Discussion (Misc queries) |