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 spreadshe...
excel
Excel for web
Excel on Mac
Macros and VBA
Charla74's avatar
Charla74
Iron Contributor
May 24, 2020

Jwalton 

 

Collaborate on the Excel version via Sharepoint?

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.
    • Jwalton's avatar
      Jwalton
      Copper Contributor
      May 27, 2020
      Got it - thank you for your help!

Resources