Assign macros inside a chart

[Sjodom]

Hello,

I have a program that works pretty well, but I ran into this snag. I am looking to have a pre-defined shape copied into a newly created chart with a macro attached. So far, I have created the chart, copied the shape, and attempted to confirm the macro assignment, but the shape's macro states it is currently assigned to a [shapename]_Click, even when I try to manually change it...

Is there a way to get around this? I find it neat that the end user will not need to switch between the chart (located in its own sheet) to another tab without having to use the currently hidden tabs at the bottom.

applicable coding used:

Set SwitchCharts = ActiveSheet.Shapes("Chart Switch")
::code::
SwitchCharts.Copy
ActiveSheet.Paste
Selection.Caption = "Switch Charts"
Selection.OnAction = "Chart_to_Subjects"
::code::

Thank you!

 

[Sjodom]

Nevermind. This process works. It was a user error on my labeling.