Your description suggests your users have their macro security set too high and/or the file is not being saved to a trusted location. Macro security setting in Word 2007 & later are essentially the same as for previous versions. Your users should go to Word Options>Trust Centre>Macro Settings and set the security level to the 2nd option (disable all with notification). That means they'll be asked whether to allow macros in a document to run. If you store the file in a trusted location, the macros will be available without that prompt.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul, thanks for your response. It's not the macro security issue, i have checked with my testers and they all have it set to the lowest setting (enable all macros), they were advised to when we upgraded to word 07 as we have numerous documents and apps that run macros. The document is stored in one location and users access it through a dashboard type program created in access. They don't store documents locally. So with a trusted location, would each user have to set this file share up as a trusted location? It seems that this would be the only way to get this working, otherwise, we won't be able to use the macros i built and would have to find alternative means.

That is really unwise - which is why MS has '(Not Recommended)' against that option. What you should do is to create/designate a trusted location in which to store files containing the approved macro or digitally sign the documents, so they can be run without the prompts (if that's what you want), and at most have the default setting to the second option. A trusted location could be a single folder or a group of folders on the network, and you can have more than one trusted location.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]