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.

Re: My VBA code not working for other users by Jay

Jay
Tue Aug 10 11:55:07 CDT 2004

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.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org

Steve L wrote:
> 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.



Re: My VBA code not working for other users by stevenleek

stevenleek
Wed Aug 11 09:50:56 CDT 2004

Jay -

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

Steve


"Jay Freedman" <jay.freedman@verizon.net> wrote in message news:<ew7UNrvfEHA.904@TK2MSFTNGP09.phx.gbl>...
> 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.
>
> --
> Regards,
> Jay Freedman
> Microsoft Word MVP FAQ: http://word.mvps.org
>
> Steve L wrote:
> > 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.