Share Excel (.xlsm) workbook on web with macros working

Question

Hello, the last months i worked on an inventory system for our company. the problem here is, when i share it on onedrive, sharepoint or google drive, the macros can not be used. The macros buttons turn into normal forms.

I need a solution for this:
The Excel (.xlsm) workbook needs to be live shared with multiple users (workers), which can update the inventory as they work along with stock going in and stock going out. The macros have to work, because the whole workbook is linked together...
also it should work for windows and mac OS.

I hope someone will see this, on youtube or online i dont find any solution for this problem.

Answer 1

i open it with onedrive. But i cant use the macros on onedrive.
and no its not solved... i'm sorry for the late reply i am on a business trip right now.

Answer 2

Yes, Macro run only for Desktop version (4 Win is better then iOS).
So better is save files with code as ZIP to easy download from clod and local run.
Anyway you can damage your file with code, open, modyf and save from web.

Regards