Forum Discussion
Candace305
May 04, 2023Copper Contributor
Excel Spreadsheet with Code
Hello, I am trying to upload an excel Spreadsheet into teams that has code, but when I upload the code is gone, and there is no code option when I right click the tab. I tried multiple suggestions listed on the site, but I cannot get them to work. Please Help!
8 Replies
Sort By
Do you mean you try to open the file in Microsoft Teams ? Actually it's practically the same as Excel in web which doesn't support VBA.
- Candace305Copper Contributor
SergeiBaklan Hello, I created an excel that I put a code so I can when I paste a specfic number it changes what is in the cell to the correct information. It works in excel, when I upload it to teams it doesnt work.
To be sure
- you have macro enabled Excel file saved on local drive, when open in Desktop app macro works
- you upload the file on Microsoft Teams (aka on SharePoint)
- from Microsoft Teams you open the file in Desktop Excel app, and now macro doesn't work
Correct?