Autorun a macro

I'm sure I'm missing something obvious, but is there a way to make a
macro/vba program run automatically when the workbook is opened?
In my case I have a link to data on a server that refreshes on opening the
workbook and then must be manipulated. Currently I have a button to
click, but I want to avoid user forgetfulness if possible.
Thanks
Paul

Hi Paul
If its the same workbook each time you could try putting the following line
into the Workbook_Open event procedure of that workbook:

Application.Run "MacroName"

Hope that helps

Andy

"Paul Wisken" wrote:

> I'm sure I'm missing something obvious, but is there a way to make a
> macro/vba program run automatically when the workbook is opened?
> In my case I have a link to data on a server that refreshes on opening the
> workbook and then must be manipulated. Currently I have a button to
> click, but I want to avoid user forgetfulness if possible.
> Thanks
> Paul
>
>

Thanks Andy,
Sound simple, but most of that went straight over my head, so it's back
to the old VB help now to see what you're talking about.
Paul

*** Sent via Developersdex http://www.developersdex.com ***

Good afternoon Paul Wisken

Two ways:

First call your macro Auto_Open eg:
Sub Auto_Open()

Second, the above will work but you should really use the event procedures facility. Put the code for your macro in the ThisWorkbook pane within the VBE, rather than the Modules pane and then change the name to Workbook_Open().

Does that make any more sense...?

For more information about this have a look here:

http://www.cpearson.com/excel/events.htm

HTH

DominicB

Thanks everyone.
It's now working perfectly

Paul

*** Sent via Developersdex http://www.developersdex.com ***

section "thisworkbook" in vba manager and then:

Private Sub Workbook_Open()

End Sub

in a module ...

Sub Auto_Open

your code here

End Sub

As soon as the workbook is open the code in the Auto_Open sub will run