You try creating an excel addin (xla) which can be incorportated as part
of an excel instance.

Then you can run the macro using the reference 'activeworkbook '.

it's a little more complicated but there's plenty of information about
creating them on excelforum.com


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=538047