I've created a VBA macro for Excel which does some formatting of a
spreadsheet I receive weekly at work, and saves a lot of time.
However, I want to be able to just use the macro of the spreadsheet
when it is mailed to me. I though of having the macro in a blank
spreadsheet in the background while opening the new spreasheet (this
is my current solution) but, to be honest, this seems like a bit of a
botched solution! Surely there is some way to just load a macro and
run it - I want this to be as simple as possible so I can instruction
other non-macro-savvy workmates to use the macro in my abscense.

Any ideas?

Cheers,
Ian Griffiths.