One way is to save a blank workbook with the macro in it as a .xla file (save as function) Then open up Excel and use tools-add ins-browse to locate and activate the .xla file as an add-in - close excel. Will always be available for reference by any workbook as long as the add-in is selected.