Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to apply a macro to all workbooks
Whenever I open an excel workbook, or create a new work book, I want
cretain macros to be automatically applied. For example. I want following workwook open be exceuted to all abobe work books (existing and new...)" Private Sub Workbook_Open() MsgBox "Wecome, welcome..." End Sub Is there a way of doing it. I have setup this macro in personal.xlsb file, but it does not get applied when I create a new workbook or open an existing workbook. It seems to apply only to personal.xlsb file. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Apply footer code to all new workbooks | Excel Programming | |||
Use VBA to Apply various Security Levels in Workbooks | Excel Programming | |||
Apply macro to closed workbooks | Excel Programming | |||
Apply macro to closed workbooks | Excel Programming | |||
Macro for Pivot Table - Apply to multiple workbooks | Excel Programming |