Macro in Teams Alternative?

%3CLINGO-SUB%20id%3D%22lingo-sub-1412557%22%20slang%3D%22en-US%22%3EMacro%20in%20Teams%20Alternative%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1412557%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20file%20that%20allows%20multiple%20selections%20from%20a%20drop%20down%20in%20multiple%20columns%20within%20the%20spreadsheet.%26nbsp%3B%20I%20created%20this%20using%20VBA%20code.%26nbsp%3B%20Works%20perfectly%20in%20Excel.%26nbsp%3B%20I%20migrated%20this%20spreadsheet%20to%20Teams%20for%20multiple%20users%20to%20be%20able%20to%20access%20and%20update.%26nbsp%3B%20The%20macros%20don't%20work%20and%20I%20see%20now%20that%20Teams%20doesn't%20support%20Macros.%26nbsp%3B%20Any%20suggestions%20on%20how%20to%20accomplish%20allowing%20multiple%20selections%20within%20one%20field%20within%20a%20Teams%20Excel%20file%20other%20than%20using%20VBA%20code%3F%20The%20picture%20below%20is%20the%20excel%20file%20example%20where%20I%20selected%20three%20items%20from%20the%20drop%20down%20within%20one%20cell.%26nbsp%3B%20%26nbsp%3BThank%20you.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Multiple%20Selection%20Excel.png%22%20style%3D%22width%3A%20275px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F193993i85C92159834F0834%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Multiple%20Selection%20Excel.png%22%20alt%3D%22Multiple%20Selection%20Excel.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1412557%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1414822%22%20slang%3D%22en-US%22%3ERe%3A%20Macro%20in%20Teams%20Alternative%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1414822%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F677315%22%20target%3D%22_blank%22%3E%40Jwalton%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECollaborate%20on%20the%20Excel%20version%20via%20Sharepoint%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1419129%22%20slang%3D%22en-US%22%3ERe%3A%20Macro%20in%20Teams%20Alternative%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1419129%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F531239%22%20target%3D%22_blank%22%3E%40Charla74%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20save%20the%20Excel%20file%20in%20Sharepoint%20as%20well%2C%20but%20once%20I%20access%20it%20the%20macro%20code%20no%20longer%20works.%26nbsp%3B%20Any%20suggestions%20how%20to%20work%20around%20that%20in%20Sharepoint%20or%20to%20enable%20macros%20in%20Sharepoint%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1419747%22%20slang%3D%22en-US%22%3ERe%3A%20Macro%20in%20Teams%20Alternative%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1419747%22%20slang%3D%22en-US%22%3EYou%20won%E2%80%99t%20be%20able%20to%20run%20macros%20when%20the%20workbook%20is%20open%20in%20a%20browser%20window%3B%20you%20will%20need%20to%20open%20and%20run%20it%20in%20Excel%2C%20on%20your%20local%20machine.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1420286%22%20slang%3D%22en-US%22%3ERe%3A%20Macro%20in%20Teams%20Alternative%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1420286%22%20slang%3D%22en-US%22%3EGot%20it%20-%20thank%20you%20for%20your%20help!%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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. 

 

Multiple Selection Excel.png

4 Replies
Highlighted

@Jwalton 

 

Collaborate on the Excel version via Sharepoint?

Highlighted

@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?

Highlighted
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.
Highlighted
Got it - thank you for your help!