Macro that automatically runs when workbook is opened

[kluitna]

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]

Hi

Autpen() the worlds your oyster~

 

[Al Chara]

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

Private Sub Workbook_Open()
Call YourMacroName
End Sub

 

[kluitna]

Thanks for the help, that does the trick!

 

[kluitna]

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]

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!