Forum Discussion

Jwalton's avatar
Jwalton
Copper Contributor
May 22, 2020

Macro in Teams Alternative?

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. 

 

excel
Excel for web
Excel on Mac
Macros and VBA

4 Replies

    • Jwalton's avatar
      Jwalton
      Copper Contributor
      May 26, 2020

      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?

      • Charla74's avatar
        Charla74
        Iron Contributor
        May 27, 2020
        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.

Resources