Macro that automatically runs when workbook is opened

kluitna · Apr 11th, 2002, 12:15 PM

I know this is a question that has already been answered some where in the forum. because I have seen it, but can not locate it for the life of me.

What I want to do is just have a macro run whenever a given workbook is opened. How does one go about doing that?

Thanks in advance for the help
Paul

Jack in the UK · Apr 11th, 2002, 12:30 PM

Hi

Auto_Open() the worlds your oyster~

Al Chara · Apr 11th, 2002, 12:33 PM

Place the call function to your macro in the Workbook_Open event:

Private Sub Workbook_Open()
Call YourMacroName
End Sub

kluitna · Apr 11th, 2002, 01:00 PM

Thanks for the help, that does the trick!

kluitna · Apr 11th, 2002, 01:11 PM

Guess I spoke a bit soon.
Where is the workbook open event at, the code is working great, I just can't find where I need to put it.

Thanks for the help

HunterN · Apr 11th, 2002, 01:25 PM

Hi!

When you go into VBEditor for the workbook click on 'ThisWorkbook' Select Workbook under the General dropdown list. It will
create the subroutine for you. All you have to do is enter the macro that you want to run.

Happy Days!

Apr 11th, 2002, 12:30 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi Auto_Open() the worlds your oyster~ __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Apr 11th, 2002, 12:33 PM	#3
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Place the call function to your macro in the Workbook_Open event: Private Sub Workbook_Open() Call YourMacroName End Sub __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 12:15 PM	#1
kluitna Board Regular Join Date: Mar 2002 Posts: 75	I know this is a question that has already been answered some where in the forum. because I have seen it, but can not locate it for the life of me. What I want to do is just have a macro run whenever a given workbook is opened. How does one go about doing that? Thanks in advance for the help Paul

Apr 11th, 2002, 01:00 PM	#4
kluitna Board Regular Join Date: Mar 2002 Posts: 75	Thanks for the help, that does the trick!

Apr 11th, 2002, 01:11 PM	#5
kluitna Board Regular Join Date: Mar 2002 Posts: 75	Guess I spoke a bit soon. Where is the workbook open event at, the code is working great, I just can't find where I need to put it. Thanks for the help

Apr 11th, 2002, 01:25 PM	#6
HunterN Board Regular Join Date: Mar 2002 Location: Maryland Posts: 424	Hi! When you go into VBEditor for the workbook click on 'ThisWorkbook' Select Workbook under the General dropdown list. It will create the subroutine for you. All you have to do is enter the macro that you want to run. Happy Days!