You use three terms............spreadsheet, worksheet and file.
Do you mean workbook and worksheet?
Do you have a simple macro like
Sub Macro()
do things
End Sub
Or is the code a worksheet event type like worksheet_change?
If a simple macro, create an add-in from a workbook with the macro in a
module.
Add that add-in to your list of installed and loaded add-ins.
The macro will be availanle for all open workbooks.
Or if just for your own use, place the macro in your Personal.xls workbook.
If event type code, you will have to post it so's we can figure out the best
method of making available.
Gord Dibben MS Excel MVP