rodcon


How do you make a macro run as soon as the Excel file it is attached to is opened The version is Excel 2000. I have searched the help files and some forums already.

Does anyone have any advice





Re: Autoexecuting macros

MyLady


Hey,

If you put a macro named Auto_Open() in a regular module, it will run whenever the workbook is manually opened.

Sub Auto_Open()

'insert code to run when the file is opened

End Sub

If you put a macro named Workbook_Open() in the ThisWorkbook code module, that macro will run upon opening the workbook.

Private Sub Workbook_Open()

'insert code to run when the file is opened

End Sub

Best Regards

Cathrine