Disabled VB Editor Button and Macro Buttons

J

jean grey

Hi everyone. This is my first post here.
I have recently opened the MS Office Excel 2007.
I wanted to create a VBA code, but the VB editor and macros buttons are all
disabled in the Developer ribbon.
There are no macros running.
There are no active add-ins.
No workbook is currently opened.
I'm running MS Excel via the MS Virtual PC 2007.
Could running it from a virtual PC be the cause?
Or could it be something else? :(
 
P

Per Jessen

Hi

A macro can't stand alone, so you have to open a workbook (can be empty).

Hopes it helps.
 
J

jean grey

Hello, Per.
I opened an empty workbook just to make sure it's clean of macros.
Still, the said buttons are disabled. :(
 
C

Charlie

The only other reason I can think of that said buttons might be disabled is
that your cursor is in the function edit bar not in a cell.
 
J

jean grey

Hi Charlie. Nope, my cursor was in a cell.

Anyway, since I had no time for troubleshooting,
I had no choice but to re-install MS Excel.
Now, the buttons are enabled.

Thanks for the ideas, though. :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top