Getting System Error &H80070057 (-2147024809)

user_12397524 0
Viewed 3408

I've been running a workbook with a few macros in it for a couple of years, and I've suddenly started getting this error thrown at me for some navigational buttons (shapes linked to macros that are simply ThisWorkbook.Sheets("sheet_name").Activate).

Other Macros within the workbook seem to work OK, but I can't get into the VBA editor to see any of the code anymore - I get to the VBA interface, but when I go to open the Module, nothing happens.

And to cap it all off, when I try to save the workbook, I'm just getting an error saying 'Document not saved'.

vba excel
3 Answers

I had the same issue. I opened the VBA code module and then selected Debug then Compile VBAProject. I then closed the Visual Basic Editor and the error seems to have been resolved. Have only had the issue the once so can't be 100% sure it will work in every instance but worth a go.

user_67356970

Suggest you open a backup copy of this file (if you have one), export the broken module and then in your current file, remove the broken module and import the clean version.

user_167081070

We had the same problem in a file that was drawing data from an external source and saving itself automatically every minute. What worked for us was just replacing the entire file with a backup from 2 days ago.

We also had the "Document Not Saved" error, which was solved by upgrading the file from .xls to .xlsx

user_7576610
Related