Excel VBA code window opened cropped and can t view code

Question

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?

Answer 1

So it turns out after some online research that a straightforward open and repair can resolve the difficulties. However, if anyone knows what's causing this issue, I'd welcome hearing your insights.

I hope this helps you.