VB Code:
  1. Private Sub Workbook_SheetActivate(ByVal Sh As Object)
  2.     If (Sh.Name = "Sheet1") Then
  3.         MsgBox "Hey, whaddayaknow Sheet1's been selected"
  4.     End If
  5. End Sub

Place this code inside of the "ThisWorkbook" module & enjoy!!!