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, 13 views)

Attached Files

assigningmacrotochartsheet.xlsm (28.2 KB, 5 views)