how do i unblock macros in excel?

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

This does not work for me, the files are in a local folder on my personal computer.

I have created some macros to save time and effort but I have spent more than 30 minutes looking for a solution. Nothing works.

Macros are enabled in the Trust Center

The file is saved as macro-enabled

Macros are created by myself

Developer tab options took me to the same place.

Any solution?

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.

My macro still disabled. I want it to be active

I want all micros to to be always enabled