[rml]

I have a word doc that uses a macro for a dropdown list. I used this as a
work around to the restriction of 25 entries on a normal dropdown list. My
question is, for people to use this doc, they have to have the macro security
setting at low. I'm going to be distributing this doc and want to make it a
user friendly as possible. How can I get around the security issue?

Thanks.

[Jezebel]

Sign your VBA project: either buy a certificate or set up a corporate
certificate. Either way, your users have to accept the certificate once.

It would be irresponsible (to say the least!) to encourage your users to set
their security to low.



"rml" wrote in message
...
I have a word doc that uses a macro for a dropdown list. I used this as a
work around to the restriction of 25 entries on a normal dropdown list.
My
question is, for people to use this doc, they have to have the macro
security
setting at low. I'm going to be distributing this doc and want to make it
a
user friendly as possible. How can I get around the security issue?

Thanks.

[rml]

Thanks for your help. Question. signing the vba project with cert. would be
fine for inhouse but how do I handle the doc to the general public?

Thanks again.

"Jezebel" wrote:

Sign your VBA project: either buy a certificate or set up a corporate
certificate. Either way, your users have to accept the certificate once.

It would be irresponsible (to say the least!) to encourage your users to set
their security to low.



"rml" wrote in message
...
I have a word doc that uses a macro for a dropdown list. I used this as a
work around to the restriction of 25 entries on a normal dropdown list.
My
question is, for people to use this doc, they have to have the macro
security
setting at low. I'm going to be distributing this doc and want to make it
a
user friendly as possible. How can I get around the security issue?

Thanks.

[Charles Kenyon]

If instead of a document you distribute a template it can work.
Security settings should never be set to low and do not need to be.

If your template is put in the user templates folder or the workgrou
tempates folder (or one of their subfolders) and the security option to
trust installed templates and addins is checked, your macros will run fine
in documents created from your template.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!

My criminal defense site: http://addbalance.com
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.


"rml" wrote in message
...
I have a word doc that uses a macro for a dropdown list. I used this as a
work around to the restriction of 25 entries on a normal dropdown list.
My
question is, for people to use this doc, they have to have the macro
security
setting at low. I'm going to be distributing this doc and want to make it
a
user friendly as possible. How can I get around the security issue?

Thanks.