Enabling all Macros

Question

Enabling all Macros

Anonymous

Hello,

I need to be able to enable all macros for Microsoft Excel. I have a data science bootcamp with Rutgers University and Microsoft Excel won't let me do my coursework because of "security" reasons. I have the newest version and all websites online are telling me to how to enable macros using the older version. I need to be able to enable ALL macros. Please help. Thanks!

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Answer 1

If your screen is grayed out or you are still having trouble, try using PowerShell. I have a video that shows how to do it and I included the PowerShell source code in the video description.

Even if you haven't coded in your life or even don't know what PowerShell is (it comes included with Windows), it should be pretty easy!

Enable Excel Macros with PowerShell

Answer 2

Hi Thank you for reaching out to this forum. I'm Utkarsh and as a fellow Microsoft user, I'm here and ready to help you today. I am a user like you, this is a user forum and not Microsoft directly.

Enabling All Macros in Microsoft Excel To enable all macros in Microsoft Excel, you can follow these steps:

a. Open Microsoft Excel. b. Click on the File tab in the top left corner of the Excel window. c. In the left sidebar, click on Options. d. In the Excel Options window, click on Trust Center in the left sidebar. e. Click on the Trust Center Settings button. f. In the Trust Center window, select Macro Settings in the left sidebar. g. In the Macro Settings section, select the option Enable all macros. h. Click on OK to save the changes. i. Close and reopen Excel for the changes to take effect.

I am NOT a Microsoft Agent/Employee.

I hope this is helpful! Best Regards, Utkarsh