[RESOLVED] Procedure call on sheet tab clike

[pandey_om]

hi experts
i m working in VBA ,i have a workbook which contain 3 sheets
1. PI-template 2. Admin 3. status ,
i have coded a proedure " Description" in modul "mdDescription".

i want when sheet2 (Admin) is cliked ,
the procedure "Description" call on cliked(Admin)

[billhuard]

Hi Pandey_om

put this sub in ThisWorkbook

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
    If Sh.Name = "Admin" Then
        Call Description
    End If
End Sub

[mikeyc1204]

Open the code view for your Admin sheet and paste this

Private Sub Worksheet_Activate()
    Call Description
End Sub

[mikeyc1204]

Too slow on the trigger again.

[pandey_om]

thanks the experts
both the mathod working fine.
my problem solved ,i m happy
cheerrrrrrrrrrrrrrrrrrrrrrrr