View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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.