Macros and digital signature Word

Topic

New Reply

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

Reply | Quote

Replies

[RetiredGeek]

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…

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

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 3 years, 11 months ago by RetiredGeek.
• This reply was modified 3 years, 11 months ago by RetiredGeek.
• This reply was modified 3 years, 11 months ago by RetiredGeek.

Reply | Quote

RetiredGeek wrote:

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.)

Reply | Quote

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.

Reply | Quote

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

I thank you again.

Reply | Quote

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

 

Reply | Quote

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

cheers, Paul

Reply | Quote

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”

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

Reply | Quote

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

 

Reply | Quote