I use Excel as part of Office 365 Home Premium, and recently I had a workbook I've been using for a while with macros open with the message "We found a problem with some content in 'workbook.xlsm'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes."

When I click Yes, I get this message: "Excel was able to open the file by repairing or removing the unreadable content. Removed Part:/xl/vbaProject.bin.part.(Visual Basic for Applications (VBA))"

Now, the workbook opens but without, predictably, the vba code. And, any VBA options or buttons are greyed out on the Developer tab.

I recently removed an "office 15 click to run extensibility component" in an effort to install Visio. That is the only change or update I've made.

How can I get VBA back?

Thanks.

michaelberrier wrote:
I use Excel as part of Office 365 Home Premium, and recently I had a workbook I've been using for a while with macros open with the message "We found a problem with some content in 'workbook.xlsm'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes."

When I click Yes, I get this message: "Excel was able to open the file by repairing or removing the unreadable content. Removed Part:/xl/vbaProject.bin.part.(Visual Basic for Applications (VBA))"

Now, the workbook opens but without, predictably, the vba code. And, any VBA options or buttons are greyed out on the Developer tab.

I recently removed an "office 15 click to run extensibility component" in an effort to install Visio. That is the only change or update I've made.

How can I get VBA back?

Thanks.


I had that before and the reason was.... not installed VBA.
One of office version has by default VBA not selected.

I had to run setup and install it.

I do not know if Office Home gives you any setup option but if yes check
if VBA is installed. You probably uninstalled too much.

Fixed it. The errant Visio install was hanging it up. Uninstalled Visio and everything was better.