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.