VB Code:
Private Sub Workbook_SheetActivate(ByVal Sh As Object) If (Sh.Name = "Sheet1") Then MsgBox "Hey, whaddayaknow Sheet1's been selected" End If End Sub
Place this code inside of the "ThisWorkbook" module & enjoy!!!
|
Results 1 to 4 of 4
Thread: *Resolved* OnSheet_Selection?Threaded View
|
Click Here to Expand Forum to Full Width |