View original (French)

VBA Excel 2007 grayed out

Solved
Lola -  
Polo141 Posted messages 215 Status Membre -
Hello everyone,
I would like to try the VBA in Excel 2007 that I briefly went over in class, but unfortunately for some unknown reason the VBA icon in the developer tab that I activated in the ribbon remains grayed out...
I don't want to mess too much with the rather advanced options, and if you could provide an explanation for my problem, it would really help me.
Thank you in advance.
Lola
Configuration: Windows XP Firefox 3.0.5

5 réponses

Réponse 1 / 5
Lionel
 
Hello,

I had the same issue: it was actually a software installation problem. It is necessary to install the "Visual Basic for Applications" module, which is apparently not always installed by default (it is a module provided with Excel: make sure to check all the options offered during installation).

Best regards,

Lionel.
15
Polo141 Posted messages 215 Status Membre 113
 
Perfect, thank you, it works.
Here’s what I did:

Start > Control Panel > Uninstall a program
Then click on Office
Button [Change]
Add the components running from the hard drive.
OK
Wait for the installation to complete (around 5 minutes)

And there you go.
0
Réponse 2 / 5
Grouchy
 
I had the same issue, you need to install the "Office shared components" from the installation CD.
This allows you to retrieve the necessary VBA functions for the macros.
3
Réponse 3 / 5
Lola
 
Good evening,
Thank you for your response, if I understood correctly you would like me to place Macro right next to VBA?
The problem is that Macro is also grayed out... preview here:
http://img338.imageshack.us/img338/426/sanstitreis7.png
1
inti
 
click on the "macro security" button (in the ribbon on the developer tab, right next to the large Visual Basic and Macros buttons)
Then the "trust center" window opens, click on "macro settings" and check the box "Enable all macros"

!!!!!!!!! If the problem persists (which was my case), there is a tutorial that explains it very well:
https://www.asap-utilities.com/faq-questions-answers-detail.php?m=145

My installation was actually not complete to use VBA, that’s why my macro buttons were always greyed out.
0
Réponse 4 / 5
man52
 
Good evening

you can start a macro with the mouse by clicking click µsoft and then edit it with the editor, it's not very conventional but it works.
0
man52
 
I just watched, so exactly you go to view, click the macro icon, create it by putting the name

you go back to macro view and you click edit and you'll be in the VB editor.
0
Réponse 5 / 5
Lola
 
Arf thanks but the Macro is also grayed out in the view tab :(
0