In the Workbook:


Private Sub Workbook_Open()
call macro x
End Sub

___________________________

Private Sub Workbook_Close()
call macro x
End Sub

Corey....
"Thyagaraj" wrote in message
ups.com...
Dear Friends,

I need the VB code to call a specific macro from an addin when ever
excel application is opened and call another macro when ever the excel
application is closed.

How ca this be done.......?


Thanks in advance

Regards
Thyagaraj