1 macro to run a macro on multiple sheets

[dareeldill]

I created sheet 1 & 2 of my project. Sheet 1 is an input page where a user will enter information. Sheet 2 is just a summary of the information on Sheet 1. I have a reset macro that clears the contents of multiple ranges on Sheet 1.

I need to have 10 pairs of sheets (10 input sheets & 10 summary sheets). All of the odd number sheets are identical, but with different data. All of the even sheets are identical but the data summarized is specific to the sheet before it.

When I made a copy of the first 2 sheets (added them to the end), was copied as well, with the same name as the macro on Sheet 1. The macro I had on sheet 1 still resets the data on that sheet, but not any of the copies I created. On the copy sheets, I can activate the same macro and it and it will reset the information for that specific page.

Is there a command I can use that will run the macro on a specific set of sheets all from the first sheet? So I can press a button I've assigned the reset macro on sheet 1 and it will reset all of the data on sheet 3, sheet 5, sheet 7, sheet 9, etc.

[Kaper]

You shall pass the name of the sheets to the macro.

If I understand well, you have now several copies of the same macro but residing in modules of different sheets. It's rather rarely usefull, and probably it would be better to store the macros in standard module (not sheet module).

Or may be you shall check what macros are assigned to buttons (anyway, I expect that even if it is - and probably it is - all the time the same macro, it is written not as a "sheet independent" one, but has the reference to particular sheet in it's code.

But not seeing the macro code neither the sample file it's not easy to give detailed description what exactly shall be changed.