Is there a way to program an Excel file to run a macro
when the file opens?

Paul,

Two ways.......
One...
Create a sub in a regular module named Auto_Open
e.g.
Sub Auto_Open()
' your code here or call another sub
End Sub

or in the Workbook_Open Event
Double Click on "ThisWorkbook" in the "Projects" Window
Copy and paste the following

Private Sub Workbook_Open()
' your code here or call another sub
End Sub

John

Paul Scott wrote:

Is there a way to program an Excel file to run a macro
when the file opens?

open the workbook, go to the VBE (Alt+F11), in the project explorer, click
on the project, then right click on the ThisWorkbook entry for that
workbook. Select view code. In the resulting code module, in the left
dropdown at the top, select workbook, and at the right dropdown select open.
At any point, the sub

Private Sub Workbook_Open()

End Sub

will appear in the module. When it does, call your macro from there

Private Sub Workbook_Open()

MyMacro

End Sub

That fires whenever a workbook is opened as long as events are enables.

Read about events at Chip Peasons site

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



--
Regards,
Tom Ogilvy
"Paul Scott" wrote in message
...
Is there a way to program an Excel file to run a macro
when the file opens?

Got it to work. Thanks for the help.


-----Original Message-----
Paul,

Two ways.......
One...
Create a sub in a regular module named Auto_Open
e.g.
Sub Auto_Open()
' your code here or call another sub
End Sub

or in the Workbook_Open Event
Double Click on "ThisWorkbook" in the "Projects" Window
Copy and paste the following

Private Sub Workbook_Open()
' your code here or call another sub
End Sub

John

Paul Scott wrote:

Is there a way to program an Excel file to run a macro
when the file opens?

.

I got it to work. Thanks for the help.


-----Original Message-----
open the workbook, go to the VBE (Alt+F11), in the
project explorer, click
on the project, then right click on the ThisWorkbook
entry for that
workbook. Select view code. In the resulting code
module, in the left
dropdown at the top, select workbook, and at the right
dropdown select open.
At any point, the sub

Private Sub Workbook_Open()

End Sub

will appear in the module. When it does, call your
macro from there

Private Sub Workbook_Open()

MyMacro

End Sub

That fires whenever a workbook is opened as long as
events are enables.

Read about events at Chip Peasons site

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



--
Regards,
Tom Ogilvy
"Paul Scott" wrote
in message
...
Is there a way to program an Excel file to run a macro
when the file opens?


.