Results 1 to 11 of 11
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    find macro (2002)

    When I open a documentI received from someone, I have the enable/disable macros window appear. When I look under tools|macros there aren't any.
    Are there "hidden" macros if the document uses the Control Toolbox in the creation of a form?

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

    Re: find macro (2002)

    Activate the Visual Basic Editor (Alt+F11).
    Select the document in the Project Explorer on the left hand side.
    Are there sections UserForms, Class Modules and/or Modules under the document? If so, they cause the macro warning (even if there is only an empty module without code).
    Also, double click the ThisDocument item in the Project Explorer to see if it contains any code.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Re: find macro (2002)

    Nothing shows here either...There are no user forms or class modules and double clicking ThisDocument doesn't show anything either.

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Re: find macro (2002)

    The only thing under the main heading in the Project Explorer other than "ThisDocument" is another folder called "references"...should I try deleting this one? Not sure what that one means or why it's there. Sub to that is "reference to Normal"

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

    Re: find macro (2002)

    Does the document itself contain ActiveX controls (i.e. controls from the Control Toolbox)? Those can also cause the macro warning.

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Re: find macro (2002)

    The Control Toolbox was used to put in text fields and option buttons. Would that do it? Is there a way to turn off the prompt for enablng the macros? (user just wants/needs to use the form without that "warning").

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

    Re: find macro (2002)

    Yes, controls from the Control Toolbox will cause the macro warning if macro security is not set to Low. Setting it to Low is not recommended, the warning is not for nothing. You could sign the document with a digital certificate; the user needs to trust the certificate once and will not receive the warning thereafter.

    See Description of digital signatures and code signing in Word 2002 and in later versions of Word

  8. #8
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Re: find macro (2002)

    This seems to be quite a pain as the name of the file in the title bar now changes to show "signed" and saving the file (filled in form) causes the signature to be removed.

    Is there any other solution? Maybe create the form in Excel because it seems that the macro warning isn't given there when I redid some of the buttons, etc.

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

    Re: find macro (2002)

    If you can live with only text boxes, combo boxes and check boxes, you can use the controls from the Forms Toolbar. They do not cause the macro warning. But they only work if you protect the document (or specific sections) for forms.

  10. #10
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Re: find macro (2002)

    Problem is, I need a yes/no option and, if I understand correctly, the boxes from the form would allow someone to check Yes as well as No...

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

    Re: find macro (2002)

    Yes - mutually exclusive options would require macro code <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

Posting Permissions

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