My VBA code not working for other users

[Steve L]

I have created a form in Word 2000. I have used the controls from the
Control Toolbox and not the Forms toolbox, because I want to write
some VBA code to fill combo boxes dependent on the choices the user
has made in previous combo boxes. This all works quite nicely until
someone other than myself opens the document. Then, the combo boxes
drop down completely blank and my code isn't getting executed at all.
Also, the user's see a lot of menu options greyed out e.g.
Protect/Unprotect.
It's probably something obvious I'm missing but I can't see anything
like this in the newsgroups. Any help/advice appreciated.

 

[Jay Freedman]

Hi Steve,

Most likely, the other users have their macro security level set to High,
which silently disables macros and Toolbox controls and leaves them in
design mode (which disables some menu options).

I don't think you can do anything about this from your end, except to
instruct users to set their security level to Medium (Tools > Macro >
Security) and click the Enable button in the dialog that will then appear
when they open the document.

If I recall correctly, Word 2000 can let you sign VBA code with a digital
signature, but not the whole document as you can in Word 2003. And even if
you could sign the whole document, I think the Toolbox controls (which are
ActiveX) are marked 'not safe for scripting' and would still trigger the
macro warning.

 

[Steve L]

Jay -

That's exactly what the problem is... Many thanks for your help..

Steve