ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to start a macro when openning Excel (https://www.excelbanter.com/excel-programming/330406-how-start-macro-when-openning-excel.html)

pinguino2005

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


JE McGimpsey

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.


pinguino2005[_2_]

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


Dave Peterson[_5_]

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

Paul Martin

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