| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabled VB Editor Button and Macro Buttons
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? :( |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabled VB Editor Button and Macro Buttons
Hi
A macro can't stand alone, so you have to open a workbook (can be empty). Hopes it helps. --- Per "jean grey" skrev i meddelelsen ... 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? :( |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabled VB Editor Button and Macro Buttons
Hello, Per.
I opened an empty workbook just to make sure it's clean of macros. Still, the said buttons are disabled. :( "Per Jessen" wrote: Hi A macro can't stand alone, so you have to open a workbook (can be empty). Hopes it helps. --- Per "jean grey" skrev i meddelelsen ... 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? :( |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabled VB Editor Button and Macro Buttons
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. "jean grey" wrote: Hello, Per. I opened an empty workbook just to make sure it's clean of macros. Still, the said buttons are disabled. :( "Per Jessen" wrote: Hi A macro can't stand alone, so you have to open a workbook (can be empty). Hopes it helps. --- Per "jean grey" skrev i meddelelsen ... 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? :( |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabled VB Editor Button and Macro Buttons
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. :) "Charlie" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Buttons and Items in Developer Tab disabled | Excel Discussion (Misc queries) | |||
| Help: Excel Macro window run button disabled for all code in 1 module? | Excel Programming | |||
| Disabled Absolute/Relative Macro Button | Excel Programming | |||
| Why Is The Macro Edit Button Disabled? | Excel Programming | |||
| Excel 2002 Macro Run button disabled? | Excel Programming | |||
Linear Mode
