[RESOLVED] Procedure call on sheet tab clike

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".

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

Hi Pandey_om

put this sub in ThisWorkbook

VB Code:

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

Open the code view for your Admin sheet and paste this

VB Code:

Private Sub Worksheet_Activate()
    Call Description
End Sub

Too slow on the trigger again.

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