I copied the codes of highlighting the current row and column from a post in 2013 by Pecoflyer and pasted it in module 2 of a workbook containing a macro in Module 1, but when I executed the Module 2 macro, only the Module 1 macro is on the Macro list. How do I add Module 2 macro in the list? The macro in module 1 applies only to the current sheet but the macro in module 2 should run in all sheets of the workbook. I'm sorry I keep on repeating macro because I don't know any other term for it.


The code that I copied started with this line:


Private Sub Worksheet_SelectionChange(ByVal Target As Range)