MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Run a macro when a workbook is opened


Posted by Matt on January 16, 2002 8:03 AM

How do I run a sub when a workbook is first opened - I want a user form to show and several parameters to be set. I can't find it - so it must be pretty simple! Something like sub_main or form_load in VB.

Thanks.


Posted by Richard Winfield on January 16, 2002 8:13 AM

Hi

Put the code in the workbook code as workbook_open()

HTH

Jacob

Posted by Jacob on January 16, 2002 8:13 AM

Hi

Put the code in the workbook code as workbook_open()

HTH

Jacob