View original (French)

Developer Tab in Excel 2003

Charly -  
 etoil -
Hello,

I am currently reading the VBA programming guide for Excel 2007,
the only one available at FNAC, but the problem is that my company only works with version 2003.
This detail poses a problem since I cannot display the Developer tab on the Ribbon. Can you help me? 
Configuration: Windows XP Internet Explorer 7.0

9 answers

  1.
    Polux31 Posted messages 7219 Status Member 1 204
     
    There is no Developer tab in Excel 2003, nor is there a Ribbon... But a menu bar with toolbars...
    --
    “What is well conceived is clearly stated, and the words to say it come easily.”
    Nicolas Boileau
    8
  2. Polux31 Posted messages 7219 Status Member 1 204
     
    Hello,

    To display the Visual Basic toolbar:
    Excel menu bar > View > Toolbars > check "Visual Basic".

    To access the editor Ctrl + F11

    ;o)

    --
    “What is well conceived is clearly said, And the words to say it easily come.”
    Nicolas Boileau
    4
  3. CharlyWalker Posted messages 9 Status Member 1
     
    Hey, take it easy

    I'm starting out using a guide, and not having the same path to follow for programming my macros complicates my initiation. I can't really respond about the usefulness of the developer tab, but since Microsoft updates its tools to improve them, I don't think it's completely useless.
    1
  4. etoil
     
    Hello, I’m Etoil
    Here’s the answer to your question about the Developer tab. If you are using Excel 2007, then you’re in luck!!!
    Follow these steps and you will see your happiness

    Click on the Microsoft Office button, then on Options Program Name, where Program Name corresponds to the name of the program you are using, for example, Word Options.
    Click on Standard, then check the box to Show the Developer tab in the ribbon.

    :)
    1
  6. CharlyWalker Posted messages 9 Status Member 1
     
    Thank you, but I don't quite have what I was looking for.
    0
  7. CharlyWalker Posted messages 9 Status Member 1
     
    Thank you for this information, I will take note of it. Do you know if there is a way to improve the V2003 to address this issue without having to purchase the V2007?
    Thanks again
    0
  8. Polux31 Posted messages 7219 Status Member 1 204
     
    I don't see what the problem is!!! Not knowing the purpose and interest of having a "Developer" tab in v2003!!!

    --
    "What one conceives well is clearly expressed, and the words to say it come easily."
    Nicolas Boileau
    0
  9. Polux31 Posted messages 7219 Status Member 1 204
     
    1) I am calm.

    2) DIXIT: "to solve this problem without having to acquire the V2007"!!! hence my response. There is no problem. We can also create macros in the same way with Excel 2003 as with 2007. The only difference is how to access the VB editor (although Ctrl+F11 works with 2007...).

    3) DIXIT: "the fact that I don't have the same path to walk to program my macros complicates my initiation." See my post #1 (https://forums.commentcamarche.net/forum/affich-13970517-onglet-developpeur-sous-excel-2003#1) on how to achieve the same result without having the same configuration.

    There you go.
    --
    “What is well conceived is clearly expressed, And the words to say it come easily.”
    Nicolas Boileau
    0
  10. CharlyWalker Posted messages 9 Status Member 1
     
    Thank you for your responses, and I apologize if I misunderstood your exclamation points; perhaps they reminded me of certain error messages on my machine.

    Thank you again.
    0