Run Macro on Opening File (Split from Access thread)

[pellacad]

Where again do you find this "startup"?

I've looked for the "Startup" menu in "Excel - Tools" and in "Excel/VBA - Tools"...it's nowhere to be found!

Any suggestions??

Thank you!


(Note: This was split from thread http://www.mrexcel.com/board2/viewtopic.php?t=233748 in the Access forum)

 

[Joe4]

Where again do you find this "startup"?

Take a look at ElBenno's second post:

No need to worry i found the function under Tools > Startup > Display Form.

Also note, this is the Access we are talking about, not Excel (this is the Access forum)!
If you want to do it in Excel, you will need to create a User Form, and have it called with a Workbook_Open Event Procedure.

 

[SydneyGeek]

Hi pellacad,

Are you trying to do this in Excel or Access?

Denis

 

[pellacad]

I'm using Excel...

My apologies...I thought I was in an Excel forum...

But my question stands...how do I execute a VBA macro when my Excel file opens?

Thanks Denis!

 

[Joe4]

Just like I said, use the Workbook_Open Event Procedure.

Here is a write-up on event procedures:
http://www.cpearson.com/excel/events.htm