Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Running macros when Excel starts up
Hi
How do I get macros or some code to run automatically when I start up an excel worksheet? Thanks |
#2
|
|||
|
|||
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 "Solly" wrote in message ... Hi How do I get macros or some code to run automatically when I start up an excel worksheet? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Excel events even in edit mode.... | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
HELP - Running Macros in VBA | New Users to Excel | |||
How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) | |||
can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) |