Create and addin with a public method for your macro then save the
addin to 'c:\Program Files\Microsoft Office\Office\Library' or
something similar then goto Tools .. Addins in the main Excel menu and
tick your new addin. This macro will then be accesible from all other
workbooks.

Mark