Microsoft Excel file with macros doesn't work when on the drive

Excel online doesnt support Macros I'm afraid. 

The only way to run these would be to download to your computer if you havent got Dropbox installed, or, if you have open from inside the \Dropbox folder. 

Yes my excel file is in the dropbox folder on my computer, It dosent work from there either!

Thanks,

Hi from me as well, fred10865! Do you mind sending over a screenshot of what you see when trying to run a macro in an Excel file that’s saved in your local Dropbox folder?

Please don’t forget to hide any personal/confidential info that may be visible in your screenshot.

Hey fred10865! Hope you don’t mind the nudge. 

Do you still need assistance with this? If you do, please reply to my previous questions. Otherwise, in case this has been resolved in the meantime, feel free to let us know what worked for you.

Yup figured it out!

See below

[removed per Community Guidelines]

Glad to hear that, fred10865! Unfortunately, due to our Community guidelines, we had to remove the external link you shared. 

However, please don’t hesitate to post any screenshots you may have with the solution you found. We’d love to know how you fixed this issue.

hi! can you share the steps you took without the link? im running into the same issue

In Regedit (as admin), navigate to: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Security.

Find or create the DWORD VBAWarnings:

Set value to 1 (Enable all macros without warnings—global for all files; use cautiously as it's less secure).

Alternative: Set to 2 (Disable with notification—prompts on open, but no per-file hassle; click "Enable Content" for trusted files)

So when I set my option to 2, Microsoft is automatically blocking the macros. On opening, I have a message at the top that says Security Risk Microsoft has blocked macros from running because the source of this file is untrusted. I added Dropbox as a trusted site and I still get this error. Any advice or is my only solution to edit the security to 1?

Hey lanos, would you mind sending us a screenshot of the error?

I'd also appreciate it if you could give us some more info on what you'd like to achieve exactly.

We'll be able to assist you further once we have this info.

Thanks!