News, tips, advice, support for Windows, Office, PCs & more. Tech help. No bull. We're community supported by donations from our Plus Members, and proud of it
Home icon Home icon Home icon Email icon RSS icon
  • Macros and digital signature Word

    Posted on veteran Comment on the AskWoody Lounge

    Home Forums AskWoody support Microsoft Office by version Office 2019 for PC Macros and digital signature Word

    This topic contains 8 replies, has 4 voices, and was last updated by  veteran 1 month ago.

    • Author
      Posts
    • #1980351 Reply

      veteran
      AskWoody Plus

      Created a macro and when I try to run it, it seems I need a digital signature. Is this true?

      And why, if true?

       

      Thank you

    • #1980373 Reply

      RetiredGeek
      AskWoody MVP

      Veteran,

      You just need to adjust some of your settings in the Trust Center.

      File -> Options -> Trust Center -> Trust Center Settings…

      Trusted Locations -> Add new location…

      TrustedLocations
      Use the browse button to add the location of your Word Document with the Macros.
      SelectLocation

      My personal preference is to just add my Word directory (folder) and then check the Subfolders of this location are also trusted check box.

      Note: you can also use the Trusted Documents vs Trusted Location if you just want to allow it for this one document. It’s a pain to add every document but it is better security. YMMV!

      HTH 😎

      May the Forces of good computing be with you!

      RG

      PowerShell & VBA Rule!
      Computer Specs

      • This reply was modified 1 month, 1 week ago by  RetiredGeek.
      • This reply was modified 1 month, 1 week ago by  RetiredGeek.
      • This reply was modified 1 month, 1 week ago by  RetiredGeek.
      Attachments:
      • #1980800 Reply

        mn–
        AskWoody Lounger

        My personal preference is to just add my Word directory (folder) and then check the Subfolders of this location are also trusted check box.

        Note: you can also use the Trusted Documents vs Trusted Location if you just want to allow it for this one document. It’s a pain to add every document but it is better security.

        Even better security would be to just sign the documents you want to trust.

        Self-signing and trusting your own signature is possible, you just need to have the self-made certificate to compare the signature to on every computer you want it to apply on.

        (Oh, sure, you could also set up your own certificate authority and then add that as a trusted authority to your PCs, if you really want to… all the necessary tools are free, all it takes is work.)

    • #1980415 Reply

      veteran
      AskWoody Plus

      Thank you so very much.  I have a problem…I tried to add new location of

      C:\Users\Nan\Documents and get message it has already been added to my trusted locations.

      But when I try to run the macro, I still get the message.  Am embarrassed to say I can’t find path to Word to try to enter that in new location.  Ugh.

    • #1982162 Reply

      veteran
      AskWoody Plus

      Finally, after repeated tries over 2 days, the path above was accepted.

      I thank you again.

    • #1983304 Reply

      veteran
      AskWoody Plus

      Yet again I have been unsuccessful.  My settings in Trust Center for Macro Settings are “Disable All…with notification” and have turned off “Trust access…”

      The path to my documents is in Trusted Locations

      “Allow documents …” in Trusted Document

      Thank you for your patience.

      Veteran

       

      Attachments:
      • #1983727 Reply

        Paul T
        AskWoody MVP

        Veteran, you can post screen shots directly (easier for us). Take shot with Windows Snipping Tool, save as PNG, post PNG file.

        cheers, Paul

    • #1983759 Reply

      RetiredGeek
      AskWoody MVP

      Veteran,

      The path to Word should be something like:

      “C:Program Files (x86)\Microsoft Office\root\Office16\WINWORD.EXE”

      The above is for Office 365. The easiest way to find your path to Word is to right click on your Word Shortcut, select properties, then on the Shortcut tab copy the value in the Target field.

      However, you shouldn’t need need that is your trusted locations only the path to where the document containing the Macros (VBA) is stored, as per my example above.

      In your screen shot I see that Sub-Folders is DISABLED. If your document is not in the main Documents folder this will not work.

      Try finding your document in File Explorer then in the navigation bar right click and select “Copy address as text”

      CopyAddrAsText
      Now go to your trust center and add a new location to Trusted Locations and paste the value into the Path: box.

      HTH :cheers:

      May the Forces of good computing be with you!

      RG

      PowerShell & VBA Rule!
      Computer Specs

      Attachments:
    • #1983780 Reply

      veteran
      AskWoody Plus

      Thank you both so much!  I realized yesterday that I hadn’t checked sub-documents and, so far, I’m in business.

      I did notice that the first time I ran the macro that the ‘busy’ wheel stayed on screen for what seemed a long time, but after that running the macro went smoothly.

      Appreciate all your help

       

    Please follow the -Lounge Rules- no personal attacks, no swearing, and politics/religion are relegated to the Rants forum.

    Reply To: Macros and digital signature Word

    You can use BBCodes to format your content.
    Your account can't use Advanced BBCodes, they will be stripped before saving.