Find Current Tab open?

[galantis]

hi,

I am trying to work out which Tab is current been viewed/opened. My button does differrent thing depending if Tab 1 or Tab 2 etc is current been viewed.

thanks.

My idea so far (which doesn't work is): The first statement is also true.

Private Sub cmdPrintModule_Click()
Dim tbtab As Page
For Each tbtab In Tab1.Pages
If tbtab.Name = Me.Tab1.Pages("General").Name Then
Call PrintGeneral
ElseIf tbtab.Name = Me.Tab1.Pages("Piping").Name Then
Call PrintPiping
End If
Next
End Sub