Unable to enable macros in excel

Hi Furkaan,

Thanks for your input.

"You'll see a few options for macro security. The most permissive 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."

Nope, I set it to "Disable all macros with notification" and yet the red bar warning me that macros are disabled does not offer an option to enable them. I Also tried with "Enable all macros (not recommended)" and macros remained blocked.

"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."

There is no option to unblock the file.

"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."

Already did this and it didn't work.

"You can create a digital signature for a file by following these steps: Click the File tab. Click on Info. Click the Protect Document button. Click on Add a Digital Signature. In the Select a Certificate dialog box, select the certificate that you want to use to sign the file. Click Sign."

This defeats the whole purpose of having a macro in my excel, since what I want to do is precisely be able to manipulate it.

I should also repeat something I said in the initial thread: this is happening for a file I created with macros I wrote myself. Nothing fancy either, just some goalseek functions.

Hi,

Thank you for reaching out. My name is Furkaan, a user just like you. I’d be happy to help you with your concerns. There are two main reasons why you might be unable to enable macros in Excel:

Security Settings: By default, Excel has security settings in place to prevent malicious macros from running. This is a good thing, because macros can automate tasks, but they can also be used to spread viruses or steal data.

File Properties: If the specific Excel file you're trying to use has macros, the file itself might be blocked.

Here are two ways to address these issues:

Change Macro Settings in Trust Centre:

Go to the File tab. Click Options at the bottom. In the Excel Options window, click on Trust Centre on the left sidebar. Click on Trust Centre Settings. Within the Trust Centre window, click on Macro Settings on the left sidebar. You'll see a few options for macro security. The most permissive 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. You can do this by following these steps:

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.

You can create a digital signature for a file by following these steps:

Click the File tab. Click on Info. Click the Protect Document button. Click on Add a Digital Signature. In the Select a Certificate dialog box, select the certificate that you want to use to sign the file. Click Sign.

I hope I can find a satisfactory solution to your problem. If you have any additional questions or concerns, please don’t hesitate to reach out. Best Regards, Furkaan

Hi,

Thank you for reaching out. My name is Furkaan, a user just like you. I’d be happy to help you with your concerns. That's frustrating! It sounds like you've tried all the usual steps for enabling macros in a file you created yourself. Here are a couple of additional things to try:

Check File Format: Excel saves files with macros in a different format than regular spreadsheets. Ensure your file is saved as a Macro-Enabled Workbook (.xlsm) instead of the default .xlsx format.

Go to File > Save As In the "Save as type" dropdown, choose Excel Macro-Enabled Workbook (.xlsm) Disable Add-Ins: Conflicting add-ins can sometimes interfere with macros. Try disabling any add-ins you have installed:

Go to File > Options > Add-Ins Select COM Add-Ins from the dropdown menu and click Go Uncheck any add-ins and click OK. Restart Excel and try enabling macros again. Repair Office Installation: In some cases, a corrupted Office installation can cause macro issues. Consider running a repair of your Office installation. This won't affect your data but can fix potential problems.

Check for Conflicting Security Software: Some antivirus or security software can block macros altogether. Try temporarily disabling your security software (remember to re-enable it afterward) and see if that allows you to enable macros.

If you have any additional questions or concerns, please don’t hesitate to reach out. Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below. Best Regards, Furkaan