| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Start macro when excel opens
I created a macro that does page setup routines for me (adjusts margins,
create titles, etc). I want this macro to be available everytime I open Excel. How do I do that? Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Start macro when excel opens
What to do is rename your macro as Auto_Open and this will then run when the
file is opened. eg. Sub Auto_Open MsgBox("This code runs when the workbook is opened.") End Sub Neil "ps" wrote: I created a macro that does page setup routines for me (adjusts margins, create titles, etc). I want this macro to be available everytime I open Excel. How do I do that? Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Start macro when excel opens
Thank you!
"Neily" wrote in message ... What to do is rename your macro as Auto_Open and this will then run when the file is opened. eg. Sub Auto_Open MsgBox("This code runs when the workbook is opened.") End Sub Neil "ps" wrote: I created a macro that does page setup routines for me (adjusts margins, create titles, etc). I want this macro to be available everytime I open Excel. How do I do that? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel file opens and opens and opens | Excel Discussion (Misc queries) | |||
| Excel opens 2 blank workbooks at start-up. How to correct this? | Excel Discussion (Misc queries) | |||
| Turn off "Reviewing" toolbar that opens at eXcel start? | Setting up and Configuration of Excel | |||
| start a macro everytime excel opens | Excel Programming | |||
| start a macro when file opens?? | Excel Programming | |||
Linear Mode
