Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Print embedded charts from several sheets
I have 40 plus sheet with data and embedded charts. How do I quickly select
just the charts to print at the same time? I tried selecting all sheets and then clicking on the charts but this did not work. Any ideas? Steve |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Print embedded charts from several sheets
This requires a macro or more patience than you or I have, because the
charts have to be printed sequentially. Something like this: Sub PrintAllCharts() Dim ch As Chart Dim sh As Object Dim co As ChartObject ' get all chart sheets For Each ch In ActiveWorkbook.Charts ch.PrintOut Next ' get all charts (chart objects) in all sheets (worksheets and chart sheets) For Each sh In ActiveWorkbook.Sheets For Each co In sh.ChartObjects co.Chart.PrintOut Next Next End Sub - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Steve" wrote in message ... I have 40 plus sheet with data and embedded charts. How do I quickly select just the charts to print at the same time? I tried selecting all sheets and then clicking on the charts but this did not work. Any ideas? Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print multiple excel sheets in color | Setting up and Configuration of Excel | |||
How to print a selected number of sheets? | Excel Worksheet Functions | |||
Newbie seeks suggestion on recording new macro to print sheets | New Users to Excel | |||
Selecting Embedded charts in Active Sheets programmatically | Charts and Charting in Excel | |||
In Excel, how do I print the workbook sheets to 2sided paper? | Excel Discussion (Misc queries) |