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
