VB code to call a macro......?

  • Thread starter Thread starter Thyagaraj
  • Start date Start date
T

Thyagaraj

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
 
In the Workbook:


Private Sub Workbook_Open()
call macro x
End Sub

___________________________

Private Sub Workbook_Close()
call macro x
End Sub

Corey....
 
Same answer to your previous post, use personal.xls.
Or put the code in the same events of your add-in.

NickHK
 
NickHK said:
Same answer to your previous post, use personal.xls.
Or put the code in the same events of your add-in.

NickHK
Click to expand...

Dear NickHK,

I am unable to get the code, can u just tell me what exact code to put
and where to put ( whether in the work sheet or in a module)

Regards
Thyagaraj
 
Back
Top