Hi Killian

Thanks for the advice...unfortunately I cannot open Zip files on my work computer! I think my employers have a morbid fear of them (not sure why they cannot leave it down to the individual's discretion...)

This is the method that I have adopted:

1. I save the spreadsheet/presentation with the macros in them.
2. I create a new button on the menu bar and customize it so that it calls the macro
3. This button is now availabel in other spreadsheets/presentations.

The only drawback to this is that I still have to keep the original spreadsheet/presentation.

Are add-ins very difficult to make? I have never used/done them before?

Thanks