VBA: add a TAG property to the Chart object
A chart in a worksheet has a name, the only way to identify the chart in VBA is to use the shape name.
But when the user moves the chart to an other sheet and back, the name of the chart changes! I understand that it is necessary that the name changes, but at this point we can not identity the chart anymore.
So a TAG property (same as in ActiveX controls) would be very helpful to find the right chart within a macro.
4
votes

1 comment
-
Andreas Killer commented
Yes, uniquely identify a chart is the problem.