Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #108158

Re: Office 365 Home Premium Excel VBA greyed out on Developer tab

Show all headers | View raw

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.

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Office 365 Home Premium Excel VBA greyed out on Developer tab michaelberrier <michaelberrier@gmail.com> - 2015-11-14 07:19 -0800
  Re: Office 365 Home Premium Excel VBA greyed out on Developer tab witek <witek7205@gazeta.pl.invalid> - 2015-11-14 19:30 -0600
  Re: Office 365 Home Premium Excel VBA greyed out on Developer tab michaelberrier <michaelberrier@gmail.com> - 2015-11-15 04:39 -0800

csiph-web