I saw related posts on other forums about this (see: http://www.mrexcel.com/forum/showthread.php?t=372534 ), but I tried everything, did not find success.
Here's the situation: I have a .xlsm workbook (named "PTPro.xlsm") that contains about 2,000 lines of VBA code in a module and 6-7 large custom forms, each with its own huge piece of code. Earlier today I worked on the project, and everything was in order. I saved, closed and opened the file 20 times throughout the process. I have never received an error message. It should be noted (in case this is important) that I saved directly to the USB flash drive from Excel.
When I brought the project home tonight, I tried to open it to make quick changes. This is when I received the following sequence of error messages:
"Excel found unreadable content in" G: \ PTPro \ PTPro.xlsm. "Do you want to restore the contents of this book? If you trust the source of this book, click" Yes. "
After clicking "Yes", a new dialog box opens with the following error message:
"Excel was able to open the file by restoring or deleting unreadable content. Deleted part: /xl/vbaProject.bin. (Visual Basic for Applications (VBA))"
My only option at this point is to click Close, which loads the book.
When I press Alt + F11 to view the VBA editor, the entire VBA project (modules, custom forms, macros, etc.) FULLY REMAINS !!!
, , Excel, , 4 ( , -). , , , - , (, , ). .
, -, , , . .
, , , !!!
!!!