Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Launching Excel macro for every workbook opened.
What I want to do is attach a formatting option to a toolbar button. I can
generate the formatting and record the macro to do it. I then want to attach the resulting macro to an icon on the toolbar. (I can do all of that. The macro is fine and attaching it to the button is ok.) Then I need to put the macro in a place that it will run on any sheet that I have open but macros will only run from open workbooks. That's where the Personal Macro Workbook (PMW) comes in. This is a hidden workbook that opens when Excel is opened but is not visible. (It is standard Excel functionality.) You save macros there and then they can be run in any open workbook because the PMW is open although not visible. I have located 4 XLSTART folders on my machine. I put workbook named PMW is each one of them. If I click on the PMW file in the XLSTART folder it opens, is hidden, and the macro runs from any other workbook that I open. The problem - When Excel starts it should open everything in the XLSTART folder including PMW. It does not. It opens book.xlt and the PDF maker add-in but not PMW. Does anyone know what I can try to get this to work? Thank you very much! ~zero |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Launching Excel macro for every workbook opened.
You have replies at your other posts.
AbsoluteZero wrote: What I want to do is attach a formatting option to a toolbar button. I can generate the formatting and record the macro to do it. I then want to attach the resulting macro to an icon on the toolbar. (I can do all of that. The macro is fine and attaching it to the button is ok.) Then I need to put the macro in a place that it will run on any sheet that I have open but macros will only run from open workbooks. That's where the Personal Macro Workbook (PMW) comes in. This is a hidden workbook that opens when Excel is opened but is not visible. (It is standard Excel functionality.) You save macros there and then they can be run in any open workbook because the PMW is open although not visible. I have located 4 XLSTART folders on my machine. I put workbook named PMW is each one of them. If I click on the PMW file in the XLSTART folder it opens, is hidden, and the macro runs from any other workbook that I open. The problem - When Excel starts it should open everything in the XLSTART folder including PMW. It does not. It opens book.xlt and the PDF maker add-in but not PMW. Does anyone know what I can try to get this to work? Thank you very much! ~zero -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Launching and not automatically starting a new workbook | Excel Discussion (Misc queries) | |||
How to stop Excel remembering/loading macro from previously opened Workbook | Excel Discussion (Misc queries) | |||
launching macro on workbook loading | Excel Programming | |||
Run a macro when a workbook is opened | Excel Programming | |||
Run a macro when a workbook is opened | Excel Programming |