I created a chart on a sheet1 from data on sheet1
I created a VBA Event Procedure that affects that chart
I moved the chart to sheet2 using the "move chart" menu option

Here's the problem...
I moved the VBA event procedure to sheet2 and made the necessary adjustment to sheet and range references
The procedure no longer works entirely correctly because Chart5 is not a ChartObject on sheet2
I discovered that Chart5 does not appear in the Selection Pane as an object on sheet2.

Does anyone know how to make the moved chart appear as a Chart Object in the destination sheet?
Hopefully without recreating the chart as it was a PITA.

Thanks