autoexec macro

[Malc]

I have written a macro in excel, and now require it to run auto when the
workbook is opened. How can this be done?

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Frank Kabel]

Hi
two ways:
1. Put your code in the workbook_open event of your workbook module
2. Name your macro Auto_Open

 

[Dave Hawley]

Hi,

Since Excel 97 there have been Events added to Excel. Prior to this you
needed to use a macro named Auto_Open()

Right click on the Excel Icon, top left next to "File" and select "View
Code". You will now be in the Private Module of the Workbook Object
(ThisWorkbook). From the top right drop-down box (Object) select
"Workbook" you should now see;

Private Sub Workbook_Open()

End Sub

Within here place a RUN Statement, e.g

Run "MyMacro"

Where "MyMacro" is the name of your macro.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****