Can anybody help on Vb Macros..?

[Thyagaraj]

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

 

[Mark Driscol]

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

 

[Kaak]

Just Call all your macros from the one macro.

Sub MainMacro()

Macro1
Macro2
Macro3
...

End Su

 

[Thyagaraj]

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

Dear Mark Driscol,
I mean make all the macros available to be run when ever excel is
opened.



regards
Thyagaraj

 

[Mark Driscol]

Do you already have a Personal.xls file? If not, from the menus select
Tools, Macro, Record New Macro. Make sure to specify using the
dropdown that you want to save the macro in your Personal Macro
Workbook. Just record yourself doing 2-3 things (clicking cells,
switching worksheets, etc.). Close Excel, and when asked indicate you
want to save the Personal.xls file.

Then, open Excel, and from the Visual Basic Editor, erase the temporary
code you created in the Personal.xls file and put your macros into this
workbook. Each time you start Excel, these macros will be available
for you to use. Whenever you make changes to Personal.xls, Excel will
prompt you to save when you exit.

Mark