Best way to share a macro

Greeting again, Gurus.

I want to thank all of the fine people in this forum who offer their time and expertise in assisting VBA challenged individulas like myself accomplish the previsously impossible. This forum ROCKS!

On to my next problem.

I have a workbook which hundreds of suppliers use to respond to a purchase order. The suppliers send this response back to dozens of buyers, they use these responses to make adjustments, (price or quantity changes), to the PO. The reponse is always formatted with the same columns and headings, but with varying rows, depending on the size of the original PO.

Now, if I wanted to create macros to distribute to all buyers to use in filtering the data after it is returned, and format it for printing, what would be the best way to distribute these macros so that the buyers can, with minimum effort, use them on any of the workbooks?

I haven't created the macros yet, but what I envision is this. They receive the PO response via email, and open the workbook, which will have varying names. I then want them to have easy access to a button they can click to filter down to only parts with changes, format it to fit the printer, and print the document.

Of course, I had considered putting the macro into the original workbook the suppliers are using, so it would be available in the response, but most of them are "dumping" the data from their IT system into a copy of the template, and then sending it back, rather than using the origianl template I supplied.

Any suggestions?

Add-in? Uh-oh, we just went way beyond my skills.

If I did learn how to create this add-in, how difficult would it be to have the buyers install it on their own computer? Also, this is a business network, with network security, so is it likely that the buyers would be able to install an add-in?

I have never used or installed one myself, so I have no idea.

Okay, if an add-in isn't an option, what's the next best way to get this to work?

You should have no difficulty with your IT department promulgating an add in that they can vet and assign a trusted digital signature. They would (should) be a lot happier with that than you circulating an automated workbook.