I have a CommandButton1 (at least) on every worksheet in a workbook.
Very many (but not all) of these CommandButtons have exactly the same handling code. How am I best structuring the code to avoid cutting & pasting the same handling code into very many worksheets?
Do I have to have at least the CommandButton1_Clicked() event handler implemented in each of the Worksheet code modules, but then each re-directs to a shared (single) implementation of the handler in the Module code area, or is there a better way? That still involves copying and pasting the skeletal handling code to very many worksheets.

Thanks in advance for any advice. I have tried searching the web but haven't found this issue described.

MathUKteacher