|
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. |
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. |
| All times are GMT +1. The time now is 09:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com