Expert help on security and vba code needed

[Markus]

I need to send out a word form with some vba code in it every 6 months to
staff members to run on their home computer. My understanding is that they
will have a problem with this form if their security settings is medium to
high.

Is there any way, other than asking them to set their setting to low, to
allow this form to run the vba code? E.G., since they know where this form
originated, is there a way for them to set their computer to accept and run
the code in the form without having to set their security level to low every
time they receive the form?

Much thanks for any and all ideas,
Mark

 

[Jezebel]

Method 1: sign the code, and ask the users to accept your certificate.
They'll need to do this only once. If you have the budget, you can buy a
commerical software certificate. I have heard, but haven't tried this
myself, that a personal email certificate (such as you can get for free from
Thawte), will also work.

Method 2 (if it's the same code each time): Put the code in an add-in, which
the users install in their start-up folder. Use a document variable or some
such in the form document itself, so the add-in can recognise the relevant
documents.

 

[Jay Freedman]

If they have the security level set to Medium, they'll see a message
box before the form opens, with buttons for Disable and Enable. If
they click the Enable button, there won't be any problem with the
macros.

The only problem that some people might have is in trying to open the
form on a work computer that has the security level forced to High by
an administrative policy. That would mean that they can't change the
level to anything else, and the macros would be disabled.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

 

[Markus]

Jezebel,

You are a life saver. I was hoping this could be done.

Many thanks,
Mark

 

[Markus]

Jay,

Many thanks for your experience,
Mark

If they have the security level set to Medium, they'll see a message
box before the form opens, with buttons for Disable and Enable. If
they click the Enable button, there won't be any problem with the
macros.

The only problem that some people might have is in trying to open the
form on a work computer that has the security level forced to High by
an administrative policy. That would mean that they can't change the
level to anything else, and the macros would be disabled.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.