![]() |
How to start a macro when openning Excel
Hi, I will like to know how to run a macro in Excel 97 when I open a a workbook in excel. The idea is that once i open a specific file in excel it automatically runs a macro. I need urgent help in this one. Thanks, Penguin. -- pinguino2005 ------------------------------------------------------------------------ pinguino2005's Profile: http://www.excelforum.com/member.php...o&userid=23833 View this thread: http://www.excelforum.com/showthread...hreadid=374866 |
How to start a macro when openning Excel
Take a look here for a description of a Workbook_Open event macro:
http://www.mvps.org/dmcritchie/excel/event.htm#wb_open also, http://cpearson.com/excel/events.htm In article , pinguino2005 wrote: I will like to know how to run a macro in Excel 97 when I open a a workbook in excel. The idea is that once i open a specific file in excel it automatically runs a macro. I need urgent help in this one. |
How to start a macro when openning Excel
I do not need to open the workbook automatically, i need to run the macro automatically when the workbook is open, Thanks. I really need this answer as soon as possible -- pinguino2005 ------------------------------------------------------------------------ pinguino2005's Profile: http://www.excelforum.com/member.php...o&userid=23833 View this thread: http://www.excelforum.com/showthread...hreadid=374866 |
How to start a macro when openning Excel
Take a look at those links again.
pinguino2005 wrote: I do not need to open the workbook automatically, i need to run the macro automatically when the workbook is open, Thanks. I really need this answer as soon as possible -- pinguino2005 ------------------------------------------------------------------------ pinguino2005's Profile: http://www.excelforum.com/member.php...o&userid=23833 View this thread: http://www.excelforum.com/showthread...hreadid=374866 -- Dave Peterson |
How to start a macro when openning Excel
Private Sub Workbook_Open()
MyMacroHere End Sub Regards Paul Martin Melbourne, Australia |
All times are GMT +1. The time now is 06:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com