Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print Excel Workbook When Open
Is there a way to program an Excel file to run a macro
when the file opens? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
Macro to open print window and set to print entire workbook | Excel Discussion (Misc queries) | |||
Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) |