Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a small macro that produces a floating toolbar. When you select a
chart and then press a button on the toolbar the chart configuration is set according to speciments in the code. However I would like to be able to select many charts and then just press the button. Now i have to do the same process for every chart. My code looks like: Sub SizeTheChart() Dim objChart As ChartObject Dim mySize As Double With ActiveSheet ActiveChart.ApplyCustomType ChartType:=xlUserDefined, TypeName:="Standard" With objChart .Height = 150 ......etc. Please help me how you can refer to multiple charts if possible. Thank you very much in advance. Any help appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple Active Workbooks | Excel Discussion (Misc queries) | |||
Multiple Active Workbooks | Excel Discussion (Misc queries) | |||
How can I make multiple hyperlinks active at one time? | Excel Discussion (Misc queries) | |||
Copy data from 3rd worksheets and pasting to active worksheet | Excel Programming | |||
Autofit column width of all worksheets in active workbook - an example | Excel Programming |