Print Excel Workbook When Open
Is there a way to program an Excel file to run a macro
when the file opens? |
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? |
Print Excel Workbook When Open
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? |
Print Excel Workbook When Open
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? . |
Print Excel Workbook When Open
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? . |
All times are GMT +1. The time now is 11:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com