#1
|
|||
|
|||
Error when assigning a macro to an Excel Chart Sheet
I want to have a macro to assign another macro to a chart that is in an Excel Chart Sheet. To know how to do this, I have recorded a macro. However, recorded macro don’t work when running on a new Chart Sheet and, as the picture attached shows, encounters error at “Selection.OnAction = "test01”. (See the excel attached. the name of the recorded macro is “test02” and the name of the macro I want to assign to chart sheets is “test01".
Can you guide me on this issue? Recorded macro: Sub test02() ActiveChart.ChartArea.Select Selection.OnAction = "test01" End Sub |
#2
|
||||
|
||||
My VBE agrees that OnAction is not a property supported by a Chart object. But when I try to record my own macro to see about that part, I realize I don't know how to assign a macro to a chart. I right-clicked on your chart area, but I don't see an option in the list about assigning a macro to it. What method did you use when recording your macro?
|
#3
|
|||
|
|||
Quote:
|
#4
|
||||
|
||||
Interesting; that option doesn't appear when I right-click on the area. We must be using different flavors of Excel. Guess I can't help you; sorry.
|
Tags |
chart sheet |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel data sheet size when opening powerpoint chart | Sissy | PowerPoint | 0 | 08-15-2019 04:35 AM |
Excel Macro: Multiple Search and Post in Excel Sheet | andxie | Excel Programming | 10 | 05-31-2018 05:21 PM |
Error in exporting Google Sheet to Excel | cmcmeekin | Excel | 2 | 08-03-2016 11:32 AM |
How To Open an Macro From 2003 Excel in 2013 Excel Spread Sheet? | ADubin | Excel Programming | 3 | 02-08-2015 04:57 AM |
Excel 2010 Chart SetSourceData 1004 error | pocerus | Excel Programming | 4 | 10-26-2014 08:10 AM |