I am creating a workbook to cover a four day golf tournament. The workbook has four identical worksheets, each representing individual divisions 1 thro 4, which have the same number of players. I input scores against players in a particular division, progressively over the four days. When all the results are in for any particular day I use a custom, 5 level sort to determine the winner and runner up on that day, and again, at the end, to determine the overall winner and runner up. As the data in each particular day sort is different and there are 2 results, I have 10 macros set up for each sheet

I set up the macros on Sheet 1 to do this, but the macros only works on Sheet 1. I want to use the same macros on all four sheets. How do I do this please ??

Previously in Excel 2003, a macro set up on one sheet worked on all worksheets in the workbook, but apparently not in Excel 2007