Hello everyone,
I have designed an Excel workbook on my computer that contains VBA macros. This workbook is stored in a shared folder on OneDrive and is accessed daily by multiple collaborators from different locations. However, we are facing a persistent issue: the macros are always disabled for security reasons, and we have not been able to find a way to enable them.
What We've Already Tried:
Enabling all macros in Excel's macro settings on each machine.
Right-clicking on the file, going to properties, and looking for the option to unblock under the general security tab (the option doesn't appear).
Adding the URL generated by OneDrive to trusted sites in Internet options.
Creating a self-signed certificate to sign the VBA code (the certificate does not appear in the list of available certificates in the VBA Editor).
Exporting and importing the certificate into the "Personal" store.
None of these solutions have worked, and we are at a standstill. Has anyone faced a similar issue or have any idea how to solve this? Any help would be greatly appreciated.
I have attached a sample file that illustrates the basic structure of the workbook and the macros involved.
Thank you in advance.
Bookmarks