Use the "SheetActivate" event of the Workbook object.

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If Sh.Name = "Sheet2" Then
MsgBox "You selected Sheet2."
End If
End Sub

HTH.

-----Original Message-----
Hi there

I need a macro to run, but only when a
certain 'WorkSheet' is selected
from within a Workbook containing many worksheets.

Can anyone help me with this?
--
Colin G Eastwood
.