A strange behavior in a VBA project

[gialandra]

Hi, suddenly I found macros that no longer worked. I went into the VBA editor and I found several multiplied sheets, it looks like the code is on one side and the object on the other, and the behavior of right click > view object is also anomalous. The icons also look anomalous (see attachment). Do you know if there is a method to rebuild the project's VBA hierarchy or reset the file structure to solve this strange behavior?

Thanks
Marco

2021-02-23_095754.png

[omahaNative_1023]

i have seen this before and if remember right other people had same issue many times too. i remember reading a lot about this and i did not find answer. i just thought i would mention that. but there are many articles written about this.

[gialandra]

The only answer I have had elsewhere so far has been you have to rebuild a new sheet

[omahaNative_1023]

i would agree. you might as just well accept it as corruption. why you think so many technology jobs have high turnover? no answers. =( reality. no one wants to tell truth.

[gialandra]

I am really sorry that there is no way to fix, in this file there is 11 years of work and it will not be a quick job to copy and paste everything into a new file. Anyway thanks

[gialandra]

I solved it by making a copy of the file, saving the copy as xmlx thus deleting all the VBA part and then dragging the modules and copying and pasting all the code from the original file to the copy. Now everything seems in order and it was simpler than I imagined.
Thanks