how do i unblock macros in excel?

Question

I need help unlocking macros for an assignment.

Answer 1

Thank you

Steve H

Answer 2

Yes, I solved it in the same way.

thank you very much for your reply.

Answer 3

See the reply from DanieleRistori below:

I resolved to add the folder containing files with macros to the trusted locations.

In Excel, go to File > Options > Trust Center > Trust Center Settings > Trusted Locations > Add new location

This solution worked for me too.

Answer 4

the files are in a local folder on my personal computer

I resolved adding the folder containing files with macros to the trusted locations.

In Excel, go to File > Options > Trust Center > Trust Center Settings > Trusted Locations > Add new location

That worked for me.
Thank you so much!

Answer 5

Such a mess Microsoft. The problem with all these options is that the file is no longer shared once downloaded. For me, the same file works fine on two laptops running Excel so that I can see changes made to the spreadsheet. Having two unlinked copies on separate laptops risks losing data if two people are making changes.

I was going to try transferring the file to my newest 3rd laptop that has the Office 365 issues. If I then make the location a trusted site, then hopefully I can upload that to another cloud site and share the file with the two older machines. Hoping that will allow all 3 laptops to access the one excel file and still run the macros.

Update: Well, that allowed me to get the macros running on the 3rd laptop and then also when saved to the second OneDrive. However, sharing it to first laptop didn't allow macros to work.