How do I apply an excel macro with a selection change event to all sheets?

Question

The macro is not working if I make it run on an active sheet in the code even if it is only attached to one sheet, but it works only for that sheet if I type only its name for the variable I'm using. How do I make it run on all sheets with selection change working?

Answer 1

I just applied the Workbook_SheetSelectionChange event. Yes precisely that David. Thanks guys!