how to unblock macro in powerpoint

Question

There is no option to unblock macro from a powerpoint. it tells me it is blocked but no option to unblock.

Answer 1

To unblock macros in PowerPoint, you can follow these steps:

1. Remove Mark of the Web: If the macro-enabled add-in file is downloaded from the internet, it may have the Mark of the Web, which blocks macros. You can remove this by right-clicking on the file, selecting Properties, and then checking the Unblock checkbox on the General tab, if available.
2. Use a Digital Signature: If you trust the source of the macro-enabled add-in, you can use a digital signature and trust the publisher.
3. Save to a Trusted Location: Another option is to save the add-in file to a Trusted Location so that macros are not blocked when you open the file from there.

If you still do not see the option to unblock, it could be due to the file being located on a network share or in a zone that does not allow unblocking. In such cases, consider moving the file to a local drive and then trying to unblock it again.

---

References:

• Guidance on allowing VBA macros to run in files you trust
• Additional information about Mark of the Web
• Use policies to manage how Office handles macros
• Macro-enabled add-in files for PowerPoint and Excel
• Trusted Locations

Answer 2

Hi Britany,

Thank you for posting, I am here to help you today.

To enable the MACRO on Excel follow this steps:

Go to the File tab then Click Options at the bottom and check Excel Options window. Click on Trust Centre then Click on Trust Centre Settings. Within the Trust Centre window, click on Macro Settings on the left sidebar. Check options for macro security option is Enable all macros (not recommended). However, this is not recommended due to security risks. A more balanced approach is Disable all macros with notification - this will prompt you each time you open a file with macros if you want to enable them. Click OK to apply the settings.

Unblock the File:

Right-click on the Excel file you want to enable macros for. Go to Properties. In the Properties window, click on the General tab. At the bottom, look for an option Unblock. If the checkbox is selected, click it to unblock the file. Click OK. One thing to try is to make sure the file is from a trusted source.

Click the File tab. Click on Info. Click the Centre button, and then click Trust Centre Settings. In the Trust Centre Settings dialog box, click Trusted Locations. Click Add new location, and then browse to the location of the file that contains the macros. Select the Subfolders option if you want to trust all files in the location and all subfolders. Click OK. Another thing to try is to create a digital signature for the file. This will help to ensure that the file has not been tampered with and can be trusted.

For more information you can check on this article: Enable or disable macros in Microsoft 365 files

https://support.microsoft.com/en-us/office/enable-or-disable-macros-in-microsoft-365-files-12b036fd-d140-4e74-b45e-16fed1a7e5c6

I hope you find this information helpful. Please let us know if you have any further questions If the answer is helpful, please click "Accept Answer".

Best regards,

Jansher