When you say spreadsheet are you referring to a worksheet within a file or
to the file itself.
What kind of macro. Always BEST to post YOUR macro for comments.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ajmplanner" wrote in message
...
I have a VB Macro in an Excel spreadsheet that I want to use in other
spreadsheets. What is the most efficient way to do this without copying
the
macro code from sheet to sheet.