Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I modify this macro to print the currently visible chart?
Okay, I've created a macro to print "Chart 1" in my worksheet. The code is as
follows: Sub PrintChart() ActiveSheet.ChartObjects("Chart 1").Activate ActiveChart.PlotArea.Select ActiveChart.ShowWindow = True ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True End Sub However, my worksheet has 45 charts in it and I want to be able to print the chart I am viewing at the time. Each chart is located in its own area of the worksheet so that they are the only ones visible at any one time. At present I have a menu structure with hyperlinks to each of the charts and, at the bottom of each chart, a macro button to return me back to the menu. I want to add a second macro button so that users can print the chart that's currently visible on the screen? How do I modify the above code to achieve this? Many thanks, Joe. -- If you can measure it, you can improve it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I modify this macro to print the currently visible chart?
hi Joe,
you could use ActiveWindow.VisibleRange.PrintOut that prints everything visible if you want to print only the chartobject: For Each cht In ActiveSheet.ChartObjects If Not Intersect(cht.TopLeftCell, _ ActiveWindow.VisibleRange) Is Nothing Then cht.Chart.PrintOut End If Next stefan On 22 Mai, 08:56, Monomeeth wrote: Okay, I've created a macro to print "Chart 1" in my worksheet. The code is as follows: Sub PrintChart() * * ActiveSheet.ChartObjects("Chart 1").Activate * * ActiveChart.PlotArea.Select * * ActiveChart.ShowWindow = True * * ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True End Sub However, my worksheet has 45 charts in it and I want to be able to print the chart I am viewing at the time. Each chart is located in its own area of the worksheet so that they are the only ones visible at any one time. At present I have a menu structure with hyperlinks to each of the charts and, at the bottom of each chart, a macro button to return me back to the menu. I want to add a second macro button so that users can print the chart that's currently visible on the screen? How do I modify the above code to achieve this? Many thanks, Joe. -- If you can measure it, you can improve it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Visible Sheets Macro | Excel Discussion (Misc queries) | |||
How to write a macro to modify an Excel chart | Charts and Charting in Excel | |||
How can I print a chart with visible grid lines? | Excel Discussion (Misc queries) | |||
Modify Print Macro,,, is it possible. | Excel Programming | |||
Need Help w/ Print Macro to Print All Visible Sheets (including Charts) in a Workbook | Excel Programming |