マクロを含むWordフアイルに証明書を付けてもWordフアイルが実行が出来ない。

信一宮澤 0

3601ba40-068a-45ac-8f59-5b0897edace8

自作マクロを含むWordフアイル（拡張子：docm）にデジタル署名証明書を付けても、一度保存後はマクロが実行が出来ません、何処を修正すれば良いでしょうか。

Microsoht資料の「マクロを有効にする警告を無効にする」などを参考に下記の設定です。

HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0 \Word\Security

「SkipSignatureCheckForUnsafeVBA」/「SkipSignatureCheckForUnsafeWLL」/VBAWarnings=3

「はがき印刷ウイザード」で作成後に**一度保存をして開いた場合、**働かないマクロが有りますが、それと同じ現象です。

VBAWarnings=１にすれば一度保存をして開いた場合、でもマクロは働きます

Windowsのバージョン(Windows 10 Home / 22H2)

Wordのバージョン(Word 2016 MSO　バージョン　2301)32bit

1 answer

Emily Hua-MSFT 27,526 Reputation points

2023-02-08T03:12:01.62+00:00
Hi @信一宮澤

Currently in Microsoft Q&A we only support English, could you please edit your question into English？Thanks for your understanding.

Via Translation tool, I got following infromation.

Do your files stored on a file share or network server?

If so, please refer to 'Macros from the internet will be blocked by default in Office'.

Add the file server or the network share as trusted sites, by adding its FQDN or IP address.

Add file path as trusted location in Office apps.

If the steps above do not work, please try following registry. (Serious problems might occur if you modify the registry incorrectly. Before you modify it, please remember to back up the registry for restoration in case problems occur.)

HKCU\SOFTWARE\Microsoft\Office\16.0\Word\Security\

Key: BlockContentExecutionFromInternet

DWORD Value = 0

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Emily Hua-MSFT 27,526 Reputation points

2023-02-10T09:41:40.6866667+00:00

Hi @信一宮澤

I am checking this thread, if you have a chance to be back, any issues or updates welcome to share with us.

信一宮澤 0 Reputation points

2023-02-11T08:40:21.4633333+00:00

I ask again.　

（再び質問します。）

The following additional modifications have already been made to the registry.

（レジストリについては既に下記を追加修正をしています。）

HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0 \Word\Security

「SkipSignatureCheckForUnsafeVBA」/DWORD Value = １

「SkipSignatureCheckForUnsafeWLL」/DWORD Value = １

VBAWarnings=3

Will these be left as they are, or will they be deleted and newly described below?

（これらはそのまま残すのか又は削除して新たに下記を記載するのですか。）

Key: BlockContentExecutionFromInternet

DWORD Value = 0

Emily Hua-MSFT 27,526 Reputation points

2023-02-13T09:19:23.54+00:00

Hi @信一宮澤

Thanks for your reply

If your Office was updated to the latest version, these registry keys are not needed.

If not, you may keep them.

Emily Hua-MSFT 27,526 Reputation points

2023-02-16T01:46:41.25+00:00

Hi @信一宮澤

How is it going on about this issue?

Please check in to see if the information provided was helpful.

信一宮澤 0 Reputation points

2023-02-18T07:49:19.01+00:00

Add a digital signature to a macro project

When you create Word software (extension: docm) that contains macros, save it, and then reopen it, many people experience the phenomenon that macros do not work. You can also visit the Microsoft Community (Japanese) and the Microsoft Specialty Site (Word - Microsoft Q&A) (English)) also received guidance from and responded.

Symptom: I have taken 5 measures as follows, but it does not improve.

※: If you change VBAWarnings/DWORD = 3 to DWORD = 1, the macro will work.

correspondence

1 Create a self-signed digital certificate

(1) Expand C:\Program Files (x86)\Microsoft Office\root\Office16.

(2) Run SELFCERT.EXE.

2 Import from "Personal" in the certificate store to "Trusted Root Certification Authorities

Import from the Personal store to Trusted Root Certification Authorities.

3 Add a digital signature to a macro project in Word

Add a digital signature to WOR d software (extension: docm) using a certificate.

4 Registering in "Trusted Places"

Register Word software (extension: docm) to "Trusted Location".

5 Adding a key to the "registry"

HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0 \Word\Security 。

■ Added keys and values.

Key: SkipSignatureCheckForUnsafeVBA/DWORD Value=1

Key: SkipSignatureCheckForUnsafeWLL/DWORD Value=1

Key: VBAWarnings/DWORD Value=3

Key: BlockContentExecutionFromInternet/DWORD Value = 0

Is there any more I can do?

Wordに有る翻訳ソフトを使用しています

I am using the translation software of Word

Emily Hua-MSFT 27,526 Reputation points

2023-02-24T09:35:33.0666667+00:00

Hi @信一宮澤

Since the text on image above in the post is Japanese, I would like to verify that after the above 5 operations, is there a prompt has the option for you to active or run the macro?

When you create Word software (extension: docm) that contains macros, save it, and then reopen it, many people experience the phenomenon that macros do not work.

For some security reasons, if the Office files include macros and from Internet, the macro may be blocked. This is by design now. For more, please refer to "A potentially dangerous macro has been blocked".

So, I suggest you save these Office files such as .docm on local machine directly after created.

Then go to Word > Options > Trust Center, Trust Center settings > Macro Settings, tick the box of "Trust access to the VBA project object model".

If you change VBAWarnings/DWORD = 3 to DWORD = 1, the macro will work.

The data value for VBAWarnings:

Value 3 --- Disable all except digitally signed macros

Value 1 --- Enable all macros

If these newly created files exist locally but encounter this issue, then under you case, it's recommended to check the certificate. Please ensure the certificate is valid and trusted.

Besides, accoring to article "アドインと VBA マクロが無効", you may update your Office or repair Office to check this issue.

信一宮澤 0 Reputation points

2023-02-26T09:19:20.56+00:00

Hi Emily Hua-MSFT

We corrected the three items you pointed out**, but** the result did not change and did not solve the problem.

report

I checked the box for 1Developer Macro Settings.

2 Verified the validity of the certificate.

(1) The certificate is trustworthy as attached.

(2) The key mark at the bottom of the certificate says "I have a private key corresponding to this certificate."

3 Repaired Microsoft 365 (Office).

(1) In my version, it is slightly different from the downloaded description, but I repaired it according to the instructions.

(2) When Microsoft 365 (Office) was selected, "Advanced Options", "Move", and "Uninstall" were displayed.

（3）Repair from "Advanced Options".

4 All that remains is to uninstall and install Microsoft 365 (Office).

If you are interested, the description says that it takes several minutes, but when you search the Web, it seems that this work may be in hours instead of minutes, but what is the standard?

Emily Hua-MSFT 27,526 Reputation points

2023-03-03T09:38:41.1333333+00:00

Hi @信一宮澤

If the steps above do not work, that you can not find the Security Warning like following image to enable macros.

I would suggest you open a ticket to help you troubleshoot this issue furtherly, your device can be remoted, and the Microsoft Team can also help you troubelshoot your system environment and other Word registry settings.

Thanks for your understanding.

信一宮澤 0 Reputation points

2023-03-25T05:57:15.1333333+00:00

Hello Emileaf-MSFT

We responded to many comments regarding this problem, but as a result, it did not improve.

I would like to end this problem here as I expect a full update of PC and Soto.

Thank you for your time for a long time.
Sign in to comment