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.