| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make macro available to all workbook w/o opening VBA
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to make macro available to all workbook w/o opening VBA
Store your macros in a file named PERSONAL.XLS. Save that file in your
XLSTART folder. From then on when you open Excel that workbook will be opened also, but in a Hidden Window. The Macros will be listed when you open Tools/Macros. Mike F "crapit" wrote in message ... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to make macro available to all workbook w/o opening VBA
Is it mandatory to have the filename PERSONAL.XLS ?
"Mike Fogleman" wrote in message ... Store your macros in a file named PERSONAL.XLS. Save that file in your XLSTART folder. From then on when you open Excel that workbook will be opened also, but in a Hidden Window. The Macros will be listed when you open Tools/Macros. Mike F "crapit" wrote in message ... |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to make macro available to all workbook w/o opening VBA
Any workbook in the xlstart directroy will be opened when excel is opened.
If you hide it before you save it, it will be hidden when it is opened. so the answer is no. -- Regards, Tom Ogilvy "crapit" wrote in message ... Is it mandatory to have the filename PERSONAL.XLS ? "Mike Fogleman" wrote in message ... Store your macros in a file named PERSONAL.XLS. Save that file in your XLSTART folder. From then on when you open Excel that workbook will be opened also, but in a Hidden Window. The Macros will be listed when you open Tools/Macros. Mike F "crapit" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening a Workbook with a Macro | Excel Discussion (Misc queries) | |||
| Run macro when opening workbook | Excel Discussion (Misc queries) | |||
| How to make the opening of a workbook conditional upon the opening of another workbook | Excel Programming | |||
| How to make opening of workbook conditional of opening of another workbook | Excel Programming | |||
| How do I make a macro present (like an add-in) on opening Excel? | Excel Programming | |||
Linear Mode
