| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running macro from closed workbook
Hi Alpur
Copy the macro in your personal.xls See this page http://www.rondebruin.nl/personal.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Running macro from closed workbook
Yes use a add-in.
See http://www.contextures.com/xlToolbar02.html -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Alpur" wrote in message ... Thanks Ron, but the macro has to be used by others so I didn't think I could use my personal.xls. Is there another way? "Ron de Bruin" wrote: Hi Alpur Copy the macro in your personal.xls See this page http://www.rondebruin.nl/personal.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "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) | |||
| Macro to import from one closed workbook | Excel Programming | |||
| Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ?? | Excel Programming | |||
| Executing a macro in a closed workbook | Excel Programming | |||
| Run a Macro over a Closed Workbook?? | Excel Programming | |||
Linear Mode
