Automatically Run Excel Macros Upon Opening Excel Workbook

[cyee]

Hi All,

Need your help badly.

I trying to run a macro automatically every time I open the excel workbook file using below code. But it seem not working.

I also try using "Run "Duedate_alert", Call Duedate_alert & etc but it still dont work.

Hope someone can help on this.

Please Login or Register  to view this content.

[Trebor76]

Hi cyee,

Try this code in Module3:

Please Login or Register  to view this content.

Regards,

Robert

[MarvinP]

Hi cyee,

I think you have your code behind a module instead behind the WorkBook.

http://www.excel-vba-easy.com/vba-pr...excel-vba.html explains it the easy way.
See http://www.cpearson.com/excel/Events.aspx for an in-deph explaination. Look down to "Application Events" in this link.

Or see the picture and explaination on http://msdn.microsoft.com/en-us/libr...ffice.12).aspx
to see that the WorkBook_Open event is in the code behind ThisWorkbook.

[cyee]

Dear Robert,

Yes!!! U got it!!!
Thanksssssssss you very much.

Best Regards.

[Trebor76]

You're welcome. Please don't forget to mark this thread as solved!!

[royUK]

Auto_Open has long been replaced by the WorkBook_Open event