I don't think you can do this without macros but it is possible to set templates as 'trusted' documents so macros can run without users needing to click buttons to enable them.
Talk to your IT team and ask them to organise a security certificate so you can sign the macros in the template. They can also then organise the distribution of the template to your users.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
|