Macros disabled - Greyed out in Trust Settings - Can't turn it back on

parkerbelt

Active Member
Joined
May 23, 2014
Messages
377
I was writing a program and got hung in a loop, so I ended Excel through Task Manager and now I'm getting the message "Because of your security setting, macros have been disabled." I tried going into the Trust Center to re-enable macros, but all the options are greyed out and I can't select anything. Anyone know how to fix that, so I can continue writing macros?
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
Is the file saved as an .xlsm file extension ?
Have you tried retrieving it ?
otherwise macros will be disabled.
 
Last edited:
Upvote 0
The file is saved as an .xlsm file
I had saved it before running the code, so I don't think I needed to retrieve it. I opened it right up from windows explorer.
Is there a different way to retrieve / open it?

Is the file saved as an .xlsm file extension ?
Have you tried retrieving it ?
otherwise macros will be disabled.
 
Upvote 0
Have you tried


1. Go to the file tab and click on 'Open'
2. Now click on the Recent Workbooks option on the top left.
3. Now scroll to the bottom and click on 'Recover Unsaved Workbooks' button.
4. Scroll through the list and search for the file you lost.
5. Double-click on it to open it.
 
Upvote 0
I tried that and it didn't work. Turned out that I had to just start over with a new excel file and just re-create the file and module. Thanks for trying though!!
 
Upvote 0

Forum statistics

Threads
1,213,522
Messages
6,114,112
Members
448,549
Latest member
brianhfield

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top