Is there similar code that will kick off a macro when any cell is selected in any worksheet in the entire workbook? Since new sheets will be added at any time, I cannot simply add the above Private Sub to all current worksheets.
I am looking for something like:
Private Sub Workbook_SelectionChange(ByVal Target As Excel.Range)
(although i know the above does not actually exist)
I am looking for something like:
Private Sub Workbook_SelectionChange(ByVal Target As Excel.Range)
(although i know the above does not actually exist)