Word 2003 Control Toolbox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

singeredel - 11 Feb 2005 23:51 GMT

I have created projects in VBA that contain userforms and modules that
contain procedures that are stored in separate templates from the Normal.dot
template. When I have created documents based on these templates and try to
run macros or procedures stored in these templates, the Control Toolbox will
frequently pop onto the document screen. Many times the Design icon from the
Control Toolbox will also be on the screen at the same time separate from the
Control Toolbox. I also have a problem in that simple macros accessed using
shortcut keys and used to open a specific directory will work sometimes and
at other times will just open the default directory. I cannot figure out what
is happening to cause these strange occurrences.

Signature

singeredel

Reply to this Message

Jonathan West - 15 Feb 2005 17:59 GMT

Hi singeredel

It sounds like you are running into Word's macro security features. If macro
security is set to High (it is by default) then macros will not run unless
the template has been digitally signed and the signature accepted by the
user.

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

>I have created projects in VBA that contain userforms and modules that
> contain procedures that are stored in separate templates from the
[quoted text clipped - 14 lines]
> what
> is happening to cause these strange occurrences.

Reply to this Message

singeredel - 15 Feb 2005 21:09 GMT

Thank you for your reply. My security setting is high. I had previously
created a digital signature and assigned it to the VBA project, but I am
still having the same problem. You mentioned "signature accepted by the
user." I don't know what this means. Perhaps I have missed something else
that needs to be done?

> Hi singeredel
>
[quoted text clipped - 21 lines]
> > what
> > is happening to cause these strange occurrences.

Reply to this Message

Jonathan West - 16 Feb 2005 01:53 GMT

> Thank you for your reply. My security setting is high. I had previously
> created a digital signature and assigned it to the VBA project, but I am
> still having the same problem. You mentioned "signature accepted by the
> user." I don't know what this means. Perhaps I have missed something else
> that needs to be done?

With a signed template, the first time the user opens the template, he is
prompted to trust the certificate and therefore allow the VBA code to run.
If the certyificate is not accepted, then the code will not run.

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

Reply to this Message

singeredel - 16 Feb 2005 03:19 GMT

Thanks for your input. I think I have finally figured out that you have to
open the template (.dot) file in the document editing window and go to
Tools-Options-Security and assign the digital certificate and then save the
template. I had assigned the certifcate to the Project in the VB Editor,
which apparently had no effect on my template stored in that Project. I am
not clear as to what the digital certificate assigned to the Project is for.
I could sure use a good handbook for the layperson to use VBA. I had "Word 97
Macro & VBA Handbook" but have nothing for Word 2003.

Thanks again...

> > Thank you for your reply. My security setting is high. I had previously
> > created a digital signature and assigned it to the VBA project, but I am
[quoted text clipped - 5 lines]
> prompted to trust the certificate and therefore allow the VBA code to run.
> If the certyificate is not accepted, then the code will not run.

Reply to this Message