MrExcel Publishing
Your One Stop for Excel Tips & Solutions

The code to launch a macro upon opening


Posted by tommy m on January 12, 2001 5:07 AM

I have a macro that I need to start when the spreadsheet is opened. Anyone know the the code?


Posted by Greg on January 12, 2001 7:57 AM

response: use the on open event. Go to the visual basic editor and choose thisworkbook and in the box that says general choose workbook and the on open sub should come up and just put your code in there and it will run everytime the workbook is opened.