There is a big risk that macros contained in files you access/download from a web application so Microsoft disables the macros. This protects users from malicious code running without their explicit approvals.

Are you needing this macro to run just on your machine or does it need to work on unknown users machines? I would probably put the macros in a template which is already on the machine and make that template the 'attached template' so that when the file is opened, it runs the macros from a pre-trusted location.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia