Excel VBA - Capuring Tab navigation

[dcanham]

Is there a way, with VBA, to capture the tab someone is navigating to? I would like to capture the navigation request, run some code based on the tab requested, then navigate to the tab. Thanks in advance for any help.

-Dan

 

[Fluff]

You can do that with an event

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
MsgBox Sh.Name
End Sub

It needs to go into the ThisWorkbook module

 

[dcanham]

works perfectly! Thank you

You can do that with an event

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
MsgBox Sh.Name
End Sub

It needs to go into the ThisWorkbook module

 

[Fluff]

Glad to help & thanks for the feedback