Make sure you are using Excel 2007 or higher for Windows and 2011 or higher for Mac. Macros cannot be enabled on Excel 2008 for Mac.
If you meet that requirement, try these solutions:
- Click the Microsoft Office Button or File in the ribbon, and then click Options.
- Click Trust Center, click Trust Center Settings, and then click Macro Settings.
- Click Disable all macros with notification.
- Close our of the file and reopen it. You will then be prompted to Enable macros each time you open the sheet.
If this still does not work, try choosing to Enable All Macros in the Macro Settings.
If you do not see the "Enable this content" radio button in the Macro Settings, or if you get a message that reads: "Security Alert This file contains encrypted macros that have been disabled because there is no antivirus software installed that can scan them", then (so long as you do have an active antivirus program installed) you will need to download and install the 2007 Microsoft Office Suite Service Pack 2 (SP2)
Warning This workaround may make a computer or a network more vulnerable to attack by malicious users or by malicious software such as viruses. We do not recommend this workaround but are providing this information so that you can implement this workaround at your own discretion. Use this workaround at your own risk.
To work around this issue, disable antivirus scanning on encrypted files that contain macros. To do this, follow these steps:
- Exit the 2007 Office programs.
- Click Start, click Run, type regedit, and then click OK.
- Locate and then click one of the following registry subkeys as appropriate:
- On the Edit menu, point to New, and then click DWORD Value.
- Type one of the following value names depending on the registry subkey that you clicked in step 3, and then press ENTER:
- Right-click the DWORD value that you created in step 4, and then click Modify.
- In the Value data box, type 1, and then click OK.
- On the File menu, click Exit to exit Registry Editor.
Note The steps above should not be used after Office 2007 SP2 has been installed. This registry information is also provided in the '2007 Microsoft Office Security Guide', but that documentation was created prior to the release of the Office 2007 Service Pack 2.