Hello,
I'm trying to run some code when a worksheet is activiated (when the user
views it via the tabs). I tried using this code and adding to the worksheet
I wanted via the VBA editor:

Private Sub Worksheet_Activate()
'do stuff
msgbox("TEST")
End Sub

Nothing happens when the worksheet is activated. What am I doing wrong?
many thanks.