| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically selecting active chart
Thank you, that worked, but I wish to run this macro from another sheet.
I still have to run this while my active sheet is "Benchmark Comp Chart". I wish to run it while my active sheet is titled "Misc.". thanks, "Wouter HM" wrote: Hi Curt, There is only one line of code needed: ActiveSheet.ChartObjects.Item(1).Activate HTH, Wouter . |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Automatically selecting active chart
I just recorded a macro that did the rest. I am all set now. Thanks
"Curt" wrote: Thank you, that worked, but I wish to run this macro from another sheet. I still have to run this while my active sheet is "Benchmark Comp Chart". I wish to run it while my active sheet is titled "Misc.". thanks, "Wouter HM" wrote: Hi Curt, There is only one line of code needed: ActiveSheet.ChartObjects.Item(1).Activate HTH, Wouter . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting Worksheets from active to end | Excel Programming | |||
| Selecting cells on active row | Excel Discussion (Misc queries) | |||
| selecting the currently active column | Excel Programming | |||
| Selecting an active cell | Excel Programming | |||
| Selecting the active row | Excel Programming | |||
Linear Mode
