Error: Macros must be enabled

Scenario

Macros must be enabled.

Solution

Close any open Word/Excel documents and open a blank Word/Excel document.
Select
File
Options
Add-Ins
.
Select
Disabled Items
from the
Manage
dropdown, then select
Go
.

If any PPC add-in is listed, select it, enable it, and select
OK
.
If no PPC-related items are listed, select
Close
and proceed to the next step.
Select
COM Add-ins
from the
Manage
dropdown, then select
Go
.
Make sure the PPC add-ins are checked so they’ll appear.
You'll find up to 5 PPC add-ins. The critical ones are
PPCWord12
and
PPCWord12Repurpose
for Word, or
PPCExcel12
and
PPCExcel12Repurpose
for Excel.
If the add-ins don't remain marked, verify the
Load Behaviors
in the Windows Registry.
For Word, go to the following registry locations:
Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\Word\Addins
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Word\Addins
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Word\Addins
For Excel, go to the following registry locations:
Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\Excel\Addins
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Excel\Addins
Locate the main 2 add-ins listed within these registry folders. If they aren't present in 1 location, check the next location.
Select the add-in and verify that the
Load Behavior
is set to 3.
If the
Load Behavior
isn't set to 3, double-click on
LoadBehavior
and change the value to 3.