I have a macro that serveral people in the office need to use. Our main
software allows us to run reports and dump them into Excel. Each time a user
does this is creates a new Excel file. I would like for each user to be able
to use the same macro each time they create an excel file from our software.
Is there a way to save a macro to "share" with all users? In the past we
have created one master file and the user has to copy and paste the
information into the worksheet containing the macro and then use save as.

Your help will be appreciated. CJ