ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   The Developer Ribbon Tab - buttons inactive (https://www.excelbanter.com/excel-programming/414717-developer-ribbon-tab-buttons-inactive.html)

Darlove

The Developer Ribbon Tab - buttons inactive
 
Hi, I have a slight problem. I wanted to do some coding in Ex 2007 and could
not make the buttons, Visual Basic and Macro, active (not grayed out), even
though the file is .xlsm. Simply put, I cannot get at the Editor. Any help
would be appreciated. For completeness' sake let me add that I have Ex 2003
and 2007 installed alongside each other and the editor in 2003 works smoothly.

Thank you - Darek

Rob Bovey

The Developer Ribbon Tab - buttons inactive
 
Hi Darek,

Try re-running the Office 2007 installer, choose the custom installation
option and make sure VBA is selected to be installed under the Shared
Features list.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

"Darlove" wrote in message
...
Hi, I have a slight problem. I wanted to do some coding in Ex 2007 and
could
not make the buttons, Visual Basic and Macro, active (not grayed out),
even
though the file is .xlsm. Simply put, I cannot get at the Editor. Any help
would be appreciated. For completeness' sake let me add that I have Ex
2003
and 2007 installed alongside each other and the editor in 2003 works
smoothly.

Thank you - Darek





All times are GMT +1. The time now is 04:27 PM.

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