ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   VBE in Excel 2007 (https://www.excelbanter.com/excel-worksheet-functions/192996-vbe-excel-2007-a.html)

Freshman

VBE in Excel 2007
 
Dear experts,

I installed Excel 2007 yesterday and I am new to this version. When I tried
to open VBE by right click the sheet tab and selected view code, this
selection was dimmed and could not be selected. Is there any problem with
this or any ways I can access the VBE?

Thanks in advance.

Bob Phillips

VBE in Excel 2007
 
You should be able to access VBA as normal.

If I recall correctly, VBA is not a default in the 2007 install, you have to
choose custom and select that option. Try a re-install and make sure hat you
explicitly select VBA.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Freshman" wrote in message
...
Dear experts,

I installed Excel 2007 yesterday and I am new to this version. When I
tried
to open VBE by right click the sheet tab and selected view code, this
selection was dimmed and could not be selected. Is there any problem with
this or any ways I can access the VBE?

Thanks in advance.




Freshman

VBE in Excel 2007
 
Hi Bob,

Thanks for your advice. I'll re-install the version once again. Have a nice
day.

Regards.

"Bob Phillips" wrote:

You should be able to access VBA as normal.

If I recall correctly, VBA is not a default in the 2007 install, you have to
choose custom and select that option. Try a re-install and make sure hat you
explicitly select VBA.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Freshman" wrote in message
...
Dear experts,

I installed Excel 2007 yesterday and I am new to this version. When I
tried
to open VBE by right click the sheet tab and selected view code, this
selection was dimmed and could not be selected. Is there any problem with
this or any ways I can access the VBE?

Thanks in advance.






All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com