hi
the best way i know to do that is to save the file your macro is in to the
xlstart folder as Personal.xls and hide the file. on my pc the xlstart folder
is at
C:\Program files\microsoft office\office 10\xlstart\
your personal.xls file will open in the background when xl starts and all
macros in the personal.xls file will be available to run on any file.
I have a number of macros in my personal xls and run many from a custom menu
or custom icon.

Regards
FSt1

" wrote:

I have a number of different workbooks all using the same sub
procedure. I want to put this sub procedure in just one workbook and
call this sub procedure from a number of other workbooks

How can i call a sub procedure from another workbook?