| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming a macro to run on opening a workbook
What is the code to program a macro to run when a workbook is opened?
Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Programming a macro to run on opening a workbook
Call your macro auto_open (I think)
-- Ian -- "mike" wrote in message ... What is the code to program a macro to run when a workbook is opened? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Programming a macro to run on opening a workbook
Hi ,mike
Workbook_Open event Private Sub Workbook_Open() 'Your Marco End Sub -- http://www.vba.com.tw/plog/ "mike" wrote: What is the code to program a macro to run when a workbook is opened? Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Programming a macro to run on opening a workbook
In de code of ThisWorkbook there are standard macro's like Private Sub Workbook_Open() 'Call testMacro End Su -- Kaa ----------------------------------------------------------------------- Kaak's Profile: http://www.excelforum.com/member.php...nfo&userid=751 View this thread: http://www.excelforum.com/showthread.php?threadid=47974 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening a Workbook with a Macro | Excel Discussion (Misc queries) | |||
| Enable macro on opening workbook | Excel Discussion (Misc queries) | |||
| Run macro when opening workbook | Excel Discussion (Misc queries) | |||
| How to make macro available to all workbook w/o opening VBA | Excel Programming | |||
| macro to start on workbook opening | Excel Discussion (Misc queries) | |||
Linear Mode
