how do i unblock macros in excel?

Question

I need help unlocking macros for an assignment.

Answer 1

all macros should be enabled. send update if required

Answer 2

So here's an update... I have copied the files from OneDrive to a local folder (not on OneDrive) and they work fine. The question now becomes, "what has Microsoft done to spanner OneDrive?"

Answer 3

I am having trouble removing the block from macros in Excel on my computer on a particular spreadsheet, which I am sure is safe. It is keeping the program from running. When I get to Macro Settings I see the following:

Macro Settings:

• Disable VBA macros without notification
• Disable VBA macros with notification (That is the current setting)
• Disable VBA macros except digitally signed macros
• Enable VBA macros (not recommended; potentially dangerous code can run)

-Enable Excel 4.0 macros when VBA macros are enabled (This box is currently checked)

Developer Macro Settings

• Trust access to the VBA project object model

I have tried a number of combinations, but nothing works. Suggestions?

Thanks

Answer 4

I am trying to open an Excel file that a co-worker sent me from a.mil email address and saved on my local hard drive, but I keep getting the ribbon across the top of the worksheet, telling me the macros in this worksheet are blocked. I followed the instructions you provided above and the instructions provided on the Microsoft website to unblock macros, as well as having deleted and downloaded the file several times after following the instructions on the Microsoft website.

I even went so far as to add my email domain, my co-worker's email domain, and the xlxs and xlms file extensions to the "Trusted Sites" list and then restarted my laptop. Nothing has worked, and the worksheet, which we need for work, still has macros blocked!

Answer 5

This worked for me too!