Running macros when Excel starts up

S

Solly

Hi

How do I get macros or some code to run automatically when I start up an
excel worksheet?

Thanks
 
A

Anne Troy

I think you mean workbook, not sheet, correct? Open your workbook. Hit
Alt+F11 or Tools-->Macro-->Visual Basic Editor. Double-click ThisWorkbook on
the left below your Project's name. On the right, hit the first dropdown and
choose Workbook. You can choose other events on the right-hand dropdown, but
the Workbook_Open appears already, so just place your code between the
Private... and End Sub.
*******************
~Anne Troy

www.OfficeArticles.com
 
Top