macro enabled shared spreadsheet hosted in MS Teams

[mopey12345]

Hi, any advice appreciated. We have a macro enable shared spreadsheet in a network folder drive populated by several users. The company are moving to the file store to MS Teams. The macros appear unable to run here and downloads to the desktop version. This makes several copies with the data spread across the downloaded versions. Is there anyway around this. Thanks in advance. Phil

 

[davesexcel]

Macros will not work on the web based excel, just on the desktop.
There is an option to use MS scripts for the web based excel. This is only available with the business version of 365 so I have never been able to play with it.