View Single Post
  #1   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

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.