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

Attached Images

error03.PNG (6.5 KB, 11 views)

Attached Files

assigningmacrotochartsheet.xlsm (28.2 KB, 3 views)

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?

Thank you for your reply. As the attached picture shows, I select the select the chart and then right clicked on it.

Attached Images

picture01.PNG (96.9 KB, 9 views)

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.