![]() |
|
#1
|
|||
|
|||
|
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 |
| 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 |