Hi Athena,
It sounds like you're hitting the problem described in KB article 917607:
http://support.microsoft.com/kb/917607
As described in that article, you need to add a "AllowProgrammaticMacros"
value to the registry, and set it to 1. Then the macros should run fine. For
some reason, the article talks a lot about using Group Policy editor to
control this value; but you can just leap into Regedit on your machine and
set the value there.
Hope it helps!
--
Andrew McLaren
amclar (at) optusnet dot com dot au