How to uniquely identify selected chart in VBA

[MCCCLXXXV]

Hi all,

I'm trying to create a macro to delete all charts on a sheet EXCEPT for the one that is selected prior to running the macro. How to i find a unique ID for each chart on the page. My plan was to grab the unique ID of the selected chart and then loop through all charts, compare that ID, and if it doesn't match, delete the chart in the loop. I can't use .Name because there are often charts with the same exact name in the sheet (I think this usually happens when you make a copy an existing chart that you manually named). Any ideas?

Thanks

[lecxe]

Hi

Select 1 chart and try this code to delete all other charts in the active worksheet:

Please Login or Register  to view this content.

[MCCCLXXXV]

Thanks lecxe. That worked perfectly!

[MCCCLXXXV]

anyone know if there is a way to make this such that the user could select multiple charts prior to running the macro and delete all charted except those selected?

Thanks

[lecxe]

Hi again

Select 1 or several charts in the active worksheet and try:

Please Login or Register  to view this content.