Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multiple Enbale/disable macros dialog (Word 2000 - 2003)

    Maybe we at my company have been in some sort of fog for the last several years but in the last two weeks we are seeing something with our Word templates that didn't occur before. Many of our word templates have checkboxes in them, the checkbox is from the control toolset. Security setting for Office is medium.

    When a word docment is first derived from the word template we get the enable/disable macros dialog once and we enable macros. We don't make any modifcations to the Word document and save it as a Word document (doc).

    Now we open that save word document (doc) and we get prompted to enable macros for the doc file itself and for the template it wqas derived from, in other words we get the enable/disable marcos dialog twice. This behavior does not occur on every PC we have nor does there appear to be any particular Office version, service pack installed , OS version or SP.

    OK we have been developing these templates with checkboxes, running them thru QA testing and selling to for customers for a number of yeasrs and we never saw this behavior before. So is this behavior normal and we have all been in some type of fog all these years?

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple Enbale/disable macros dialog (Word 2000 - 2003)

    Have you checked whether "Trust all installed templates and add-ins" is set in the Trusted Sources tab of Tools | Macro | Macro Security?

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Enbale/disable macros dialog (Word 2000 - 2003)

    Thanks Hans, yes "Trust all installed templates and add-ins" is set. Do you see multiple enable/disable macros dialogs?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple Enbale/disable macros dialog (Word 2000 - 2003)

    No. How do you create a new document from the template? If you do it the usual way (in the interface through File | New... or in code using Documents.Add), the document should not contain any code, userforms etc.

  5. #5
    3 Star Lounger
    Join Date
    Nov 2002
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Enbale/disable macros dialog (Word 2000 - 2003)

    That works and even works double clicking the template to derive a document but isn't that due to the template being in a trusted folder? Also if you look at the VBA code in the derived document, the thisworkbook object you will find the check boxes referred to in the document's VBA code window in the pulldown.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple Enbale/disable macros dialog (Word 2000 - 2003)

    The check boxes are stored in the document itself, unlike standard modules and userforms. Check boxes from the Control Toolbox are ActiveX controls, and ActiveX controls trigger the macro warning.

    If the template is in a trusted location, you should only get a macro warning for the document (because of the ActiveX controls). If the template is not in a trusted location, you should get two macro warnings, one for the document and one for the template.

    Have you considered signing the template with a digital signature? The users will have to accept the signature ONCE. After that, all documents and templates with that signature will be trusted automatically.

  7. #7
    3 Star Lounger
    Join Date
    Nov 2002
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Enbale/disable macros dialog (Word 2000 - 2003)

    Ok it sounds like the behavior is correct if the template is accessed directly unless it is in a trusted site or if the template has a digital signature. About the digital signature are you referring to like Verisign because I have a Verisign signature for execuables.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple Enbale/disable macros dialog (Word 2000 - 2003)

    Yes, Verisign and Thawte are well known providers of digital certificates. You sign a project in the Visual Basic Editor: Tools | Digital Signature.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •