Macro to export graphs from different sheets objects with a single button
I have created a macro to export objects from a single sheet. I now need to export objects from multiple sheets with a single button.
I have copied the same button to all other sheets wherever I need to export these objects. But when I click on the button in one sheet it only exports the object present on that sheet and doesn't export the objects from other sheets despite this being written in the macro
Pasted below are the different Sheet object numbers. so ideally it should be exporting these images from different sheets at the same time.