Run a macro when switching tabs

[jfreeman]

I would like to create a macro that would run when I switch to a certain worksheet in my spreadsheet. The macro needs to run an existing macro on two of the other worksheets. Is this possible?

Thanks,
Jerry Freeman

 

[north19701]

Private Sub Worksheet_Activate()
' your code goes here
End Sub

right-click on the sheet you want to run the macro on, select view code and paste this in. add your code as needed.