Macro to run automatically (Excel 2003)

Topic

New Reply

Is there a way to force a macro to run automatically when the user opens the spreadsheet? I can not locate any information and I know there must be a way.

Reply | Quote

Replies

A macro named Auto_Open will be run automatically when the workbook is opened.

Reply | Quote

Thanks!

It is Friday and my mind is gone. I renamed the macro auto_open and it works great!

Reply | Quote

Another option is to create a procedure named Workbook_Open in the ThisWorkbook module. It won’t work if you use a different name or if you place the procedure in a standard module. Workbook_Open is a so-called event handler. Like Auto_Open, Workbook_Open will be run each time the workbook is opened.

Reply | Quote

Thanks for the information. I have everything working and it is so great.

Reply | Quote

Beware of a limitaiton of the “Auto_Open”. It only runs when manually opening a file. If the file is opened via code, a workbook_open will run but not an “Auto_open”

Steve

Reply | Quote