How do I get a macro to run everytime I enter a specific worksheet?

Everytime I enter the "Summary" tab, I would like to run a macro that I already have set up.  Can anyone tell me how I can do this using VBA? Thanks!
tiehazeAsked:
Who is Participating?
 
Patrick MatthewsConnect With a Mentor Commented:
Hi tiehaze,

Put this into the sheet module for Summary:

Private Sub Worksheet_Activate()

    'insert code or call to another sub here

End Sub


Regards,

Patrick
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.