Macro in Teams Alternative?

[Jwalton]

I have an excel file that allows multiple selections from a drop down in multiple columns within the spreadsheet.  I created this using VBA code.  Works perfectly in Excel.  I migrated this spreadsheet to Teams for multiple users to be able to access and update.  The macros don't work and I see now that Teams doesn't support Macros.  Any suggestions on how to accomplish allowing multiple selections within one field within a Teams Excel file other than using VBA code? The picture below is the excel file example where I selected three items from the drop down within one cell.   Thank you. 

[#2]

@Jwalton 

Collaborate on the Excel version via Sharepoint?

[#3]

@Charla74 

I tried to save the Excel file in Sharepoint as well, but once I access it the macro code no longer works.  Any suggestions how to work around that in Sharepoint or to enable macros in Sharepoint?

[#4]

You won’t be able to run macros when the workbook is open in a browser window; you will need to open and run it in Excel, on your local machine.

[#5]

Got it - thank you for your help!