Need to see if your shared folder is taking up space on your dropbox 👨💻? Find out how to check here.
Forum Discussion
Macros have been blocked for my Excel files.
Hi
We got problem activating Macros in Excel when opening files from dropbox.
Excel has a messages in the top saying that Macros has being blocked.
And there is no option to activate Macros, as there used to be.
Any ideas
Brgds Bent
14 Replies
Replies have been turned off for this discussion
- Rich
Super User II
I have tried to work with the files as avaiable offline, but then the path to the files is different.
A file doesn't change location when switching between online and offline, so its path would be the same. When you take your screenshots, please include examples of how you see the path changing on your files.
Here same issue, microsoft blocks the execution of the macro's. Will Dropbox provide a solution for this or do we need to use Onedrive instead?
- Hannah
Dropbox Community Moderator
Hey DeKristof, thanks for the nudge here.
Would you mind sending us some screenshots of what you see for the macros failing? Especially if you're getting some kind of error, it would be really helpful for us to have a visual.
Also, to confirm what Rich mentioned in his reply above, the location of the file shouldn't change, so if this is something you see on your end, please include a screenshot of that too.
And lastly, you are in fact using the Dropbox desktop app, right? If so, are the files in question set to "available offline" or "online-only"?
- Rich
Here same issue, microsoft blocks the execution of the macro's. Will Dropbox provide a solution for this ...
This isn't a Dropbox problem. Microsoft Office blocks all macros unless the file location is a trusted source. You can add the path of your Dropbox folder as a Trusted Location in the Trust Center Settings within the Office application that you're using. It's under File/Options/Trust Center.
