Excel Macro not available

I have Office 2013, Home and Student installed, Version 15.0.4745.1002.

In TrustCenter all macros are authorized (lowest security).

In Excel the macros funcions ar greyed out, not available, whereas in Word and in

Powerpoint macros are working.

Any idea what is the cause of this behaviour ?

Thanks for any hint.

In the meantime I have deinstalled Office with the FixIT tool, reinstalled and get the same problem!

Off_CAT tells, that there is a registry problem - but how to repair it. The standard office-tool does not help.

August 20th, 2015 10:23am

Hi Chauvesouris,

Based on your description >>Off_CAT tells, that there is a registry problem<<.

It seems that the policy is handled through registry, please go to :
HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\15.0\excel\security\VBAwarnings

You can try to delete the registry key, or you can modify the value.

VBAWarnings DWORD value signification:
Value 1: Enable All Macros
Value 2: Disable All macros with notification
Value 3: Disable all macros except those digitally signed
Value 4: Disable all without notification

Important Follow the steps in this section carefully. Serious problems might occur if you modify the registry incorrectly. Before you modify it, back up the registry for restoration in case problems occur.

Please refer to this article about how to back up and restore the registry in Windows:
https://support.microsoft.com/en-us/kb/322756?wa=wsignin1.0

Please try this method and check if it works for you, I'm glad to help and follow up your reply.

Regards,

Emi Zhang
TechNet Community Su

Free Windows Admin Tool Kit Click here and download it now
August 20th, 2015 10:24pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics