Forum Discussion
VBA Not Visible after Microsoft Error and Repair Completed
heylookitsmeSo for anyone with this issue here is the fix: I opened tools and selected VBAProject and then changed the name to something else. This caused it to drop that bad file reference object that was just pointing back to the same workbook. Not sure how it happened.
heylookitsme Further Investigation (opened in Safe Mode) allows me to open and select all of the data in the VBA Editor (which I quickly saved to word). Tools, Reference shows 5 Checked Ref Files: out of those 5 files the Locations of them are accurate and good. No Blank or unusual file references showing. However, when I view the Object Library Window there is a selection for VBAProject which is not listed in my Library Reference and the location of the file is showing the same as this file with this file being its reference. So, this is what is causing the error. Now how to remove a Reference Library that is not showing in your Refence toolbox and how to locate and add the VBAProject Reference so it can be added back into the reference library from the correct location.
heylookitsmeSo for anyone with this issue here is the fix: I opened tools and selected VBAProject and then changed the name to something else. This caused it to drop that bad file reference object that was just pointing back to the same workbook. Not sure how it happened.