Excel with VBA code in SharePoint not working

I have an excel file which has some vba code, I have moved to file to SharePoint but when I open that file, the VBA code part is not working - this is excel in web. I have synced to file on OneDrive, here when I open the excel in desktop, the VBA code part is working well. I have a question if multiple users update that excel at the same time, will it sync properly? if not what can be done? because I have se en sync issues sometimes with OneDrive and SharePoint.