Sharing Excel W/ Macros and Userforms

[hajiali]

Is there a way to Share Excel with Macros and Userforms enable using Excel online that exceeds 5 mb?

 

[Fluff]

You cannot run macros with Excel online.

 

[hajiali]

Thanks for the quick reply Fluff

How would I go about sharing the Excel with macros enabled where Multiple users can be on the Excel simultaneously?

 

[Fluff]

What version of Xl are the users running?

 

[hajiali]

excel 2016

 

[Fluff]

In that case you should have co-authoring, have a look here
https://support.office.com/en-gb/ar...uthoring-7152aa8b-b791-414c-a3bb-3024e46fb104

 

[hajiali]

I tired that and it shares a link to open in OneDrive and it will not allow excel files that exceeds 5mb

 

[Fluff]

In that case I suspect that your only option would be to share the workbook, but that is fraught with problems & I would advise against it.
https://www.ablebits.com/office-add...el-shared-workbook-share-file-multiple-users/

 

[hajiali]

what would be some of the problems?

 

[Fluff]

Along with the limitations outlined in the previous link.
I simply don't trust shared workbooks. Excel is not really designed to be shared (unlike programs such as Access) and that can cause problems & conflicts, potentially leading to loss of, or corruption of, your data.