Hello all

Hope I can get some help here.

I am working on a file, learning excel / vba. I have a document that I am programming for showing / hiding Form Controls using checkboxes. So far I have a bunch of if-then-else statements in a single module that show/hide checkboxes and dropdowns.

This morning when I came to work on the file, I double clicked it and got an error; "Microsoft Excel has stopped working" which seemed to look for a solution and resulted in a button to close Excel. I tried Open and Repair, and the file did the same thing. However, once this had happened, opening excel from the excel shortcut (rather than from a file) brought up Document Recovery in Excel, and my file was here. I can repair it but I still cant save and then open the repaired file as normal. Once I repair the file, I can see the workbook and I can edit it to my hearts content, but when I save it and close it, then reopen the file I get the same problem. After a repair, my checkboxes are misaligned also.

The repair says: Removed Records: Object from /xl/worksheets/sheet2.xml part The log file doesnt show anything but some basic xml pointing to this statement.

Saving the file without the macro results in the same problem. But a new file will save no problems.

Whats going on? And how can I get past this? Thank you in advance