Deploying word templates with macros

[LeeDownUnder]

I have a use case as follows:
I have a Word document with form fields that is to be posted on the company
intranet. The document has VBA code behind it and some VBA macros stored in
modules and VBA forms. Users will browse to the company intranet and open the
document (fill out the fields) and print. They may wish to save a copy of
the document locally or download the document to work on it locally. Macro
security on the clients is set to High.
If I place the documents in the workgroup\templates and point the intranet
link to that location then when the form is opened from here the macros work.
However if the form is saved locally and opened then the macros are
disabled.
I have read up a bit on the whole global templates / add in options although
I am still a bit confused as to how this all works. Is there any method for
retaining the current macro security setting and having the macros work when
saved locally?
An 'idiots guide' would be very helpfull...many thanks

 

[Robert M. Franz (RMF)]

Hello Lee

I have a use case as follows:
I have a Word document with form fields that is to be posted on the company
intranet. The document has VBA code behind it and some VBA macros stored in
modules and VBA forms. Users will browse to the company intranet and open the
document (fill out the fields) and print. They may wish to save a copy of
the document locally or download the document to work on it locally. Macro
security on the clients is set to High.
If I place the documents in the workgroup\templates and point the intranet
link to that location then when the form is opened from here the macros work.
However if the form is saved locally and opened then the macros are
disabled.
I have read up a bit on the whole global templates / add in options although
I am still a bit confused as to how this all works. Is there any method for
retaining the current macro security setting and having the macros work when
saved locally?

I doubt there is a clean way around this unless you really do deploy the
macros either to a file server where the user has access to (trusted
location), or into the user profile (logon script).

I much prefer the second approach, though this is due to the fact that,
historically, Word had troubles when the server name changed (or was
otherwise unavailable).

0.2¢
Robert