I have a VBA macro-enabled excel sheet posted into MS TEAMS. Users are aware that in order to run the macro, they must open the file in a desktop application. Users have recently reported issues with macros failing to execute. When I attempted to access the VBA code in the VBA editor, all I could see were code windows that had been cropped, leaving no code to be seen.
In addition, the macro listing under the developer tab displayed an empty list when I attempted to see it.
Has anyone had this happen before and is there a way to recover the VBA scripts and figure out what went wrong?