Print Excel Workbook When Open
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?
|