View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mark Driscol[_2_] Mark Driscol[_2_] is offline
external usenet poster
 
Posts: 75
Default Can anybody help on Vb Macros..?

Do you mean run these macros when the workbook is opened, or make them
available to be run?

If the first, you can put this into the ThisWorkbook module of a
Personal.xls file you put into your XLSTART directory.

Private Sub Workbook_Open()
' Code to call your macros goes here
End Sub

Mark


Thyagaraj wrote:
I have created many macros to automate many things what i do day to
day.
I know how to assign a macro to a button.

I want to create a macro to call these buttons always when ever excel
is opened.


Thanks in Advance


Regards
Thyagaraj