Working in Onedrive - Macros are disabled

[Gajendran Yadhav]

Dear Members,
I have a Macro enabled workbook, which works perfectly on individual machines.
Since my colleagues are spread across, I shared it over One Drive with rights only to edit - mean they can view and edit the workbook only online. They can't have the option to download it to the local machine.
But the issue is none of the macro is working...!!

Already there were certain threads related, but all were providing the solutions to enable macros after downloading to the local machine.

My issue is working online itself. Is there any possibility to solve this.?

Aany assistance is greatly appreciated.

Best regards,
Gajendran Yadhav

 

[Micron]

I'm no expert on the subject but can tell you that even if you can work on a file over OneDrive, you should not. The potential for data transfer interruption would be very high, resulting in file corruption. Macros are disabled by default for files that come from the internet. AFAIK, you can't work on a file on OneDrive as it's not meant for that. It's a file sharing platform with limited capabilities.

The only other approaches I'm aware of that would allow users to access a file remotely is Remote Desktop (aka Terminal Services) and Citrix. Other than that, I suppose SharePoint. The SP settings would need to be to allow only one user at a time to check out the file, otherwise you'll have synchronizing issues.

 

[Skyybot]

Your users may have to add the OneDrive location to the Trusted Locations in their individual Trust Center options?

 

[Gajendran Yadhav]

I'm no expert on the subject but can tell you that even if you can work on a file over OneDrive, you should not. The potential for data transfer interruption would be very high, resulting in file corruption. Macros are disabled by default for files that come from the internet. AFAIK, you can't work on a file on OneDrive as it's not meant for that. It's a file sharing platform with limited capabilities.

The only other approaches I'm aware of that would allow users to access a file remotely is Remote Desktop (aka Terminal Services) and Citrix. Other than that, I suppose SharePoint. The SP settings would need to be to allow only one user at a time to check out the file, otherwise you'll have synchronizing issues.

Noted, but if the users work in individual terminals, each time, we have to depend on the other person to provide data... also spread across the globe, variation of time is also a big deal

 

[Gajendran Yadhav]

Your users may have to add the OneDrive location to the Trusted Locations in their individual Trust Center options?

It is enabled and the onedrive location is added to the trust centers. Since, the users work online, the macros aren't enabled i guess??? i'm clueless.

 

[Fluff]

You cannot use VBA when working with Excel online as it's not supported.

 

[Alex Blakenburg]

Do the users have the option to "Open in Desktop" App or Open In Excel, either when they navigate to the file or when they click on the editing button ?
If they do and click on that they should be able to run the macros.