A few more thoughts:

The macros are stored in a Personal.xls file that resides in the XLSTART folder in documents&settings/[user]/applications/microsoft/Excel

I would be happy to post the macros, but was reluctant to do so as the post may seem overly complex and scare off some good thoughts!

Thanks!