All macros gone and excel wont save file because of errors

[ste33uka]

Hi my workbook macros have all gone and file wont save as it says it has errors.
I do have a backup, but this is happening every day now
backup works fine,until it is updated with a few rows of data, i dont believe the workbook has any errors
This is a snap shot of modules, where i cant click anything
anyone any ideas?
problem allways happens when i move workbook to a different pc, then the problem is on both pcs

 

[jgoomster]

was this ever resolved? we are seeing the same issue. it miraculously went away and everything seemed to be working fine. chopped it up to a vba or excel bug that we assumed must have been fixed with an update.

but no a coworker of mine is seeing the exact same thing. Even the screenshot looks familiar, with all the overlapping windows.