If the code is in standard module then you may use application.run so it will be easy fix.

If your code will be different for each sheet it may be preferable to use Worksheet variables declared WithEvents - I do not see any benefit with a workbook level event for different codes.