Print Excel Workbook When Open

[Paul Scott]

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

 

[John Wilson]

Paul,

Two ways.......
One...
Create a sub in a regular module named Autpen
e.g.
Sub Autpen()
' 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

 

[Tom Ogilvy]

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

 

[Paul Scott]

Got it to work. Thanks for the help.

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

Two ways.......
One...
Create a sub in a regular module named Autpen
e.g.
Sub Autpen()
' 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]

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



.