MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Need help with starting macros! PLEASE HELP ASAP


Posted by MatrixNeo665 on April 19, 2001 5:51 PM

Hey.
I need to know how to make it so the macro automatically starts when the excel document is pulled up. This is for a VB class and we're doing a mortgage program. I need to know how to get the macro to start automatically so it's more simplified (that's our goal, I guess). Thanks for any help. Please email me the info, if you could. I probably won't check this too often. Either use the email in the message, or use this one: geordi11@yahoo.com


Posted by Dave Hawley on April 19, 2001 7:18 PM


Hi MatrixNeo665

You need to place your code within the Private Module of "ThisWorkBook" or place a line that calls a procedure that is in a normal Module:

Private Sub Workbook_Open()
Run "MyMacro"
End Sub


The simplist way to get here is to right click on the sheet picture, top left next to "File" and select "View Code". There are many of Events within here as well, that may be better suited, like Workbook_Activate.


Dave


OzGrid Business Applications