Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running macro from closed workbook
Alpur,
No, all macros must be in currently open workbooks. The workbooks don't need to be visible, however. Most people either put the macro into their Personal.xls file (which can be optionally hidden), or into an add-in (always hidden). Both are opened every time Excel is started. HTH, Bernie MS Excel MVP "Alpur" wrote in message ... I have a macro saved in a separate workbook which is used on several spreadsheets each month. Is there a way in which I can run the macro without having to open the macro workbook everytime? There is probably a simple answer to this but I am fairly new to this game. Any help would be much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
closed workbook macro | Excel Discussion (Misc queries) | |||
Running macro from closed workbook | Excel Programming | |||
Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ?? | Excel Programming | |||
macro to delete a closed workbook | Excel Programming | |||
Run a Macro over a Closed Workbook?? | Excel Programming |