Private Sub Worksheet_SelectionChange

[Pinball]

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)

 

[Tom Urtis]

You were close. The code line is

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)

 

[Colo]

Hi. Please copy this into a ThisWorkbook module.
The event you want is already exist.

<pre>
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range)
MsgBox Sh.Name & " " & Target.Address(0, 0) & " are selected"
End Sub
</pre>