dcsimg
Results 1 to 2 of 2

Thread: [FAQ's OD] Where did the VBA IDE go in Office 2007?

  1. #1

    Thread Starter
    Super Moderator RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,649

    [FAQ's OD] Where did the VBA IDE go in Office 2007?

    In all of the Office 2007 apps the familiar toolbars and menus of previous versions have been reorganized and optimized. By default the Developer (AKA: Macros) tab (AKA: menu/toolbar) is not shown. When you opt to show the Developer tab in one Office app, it will apply to all installed Office apps so you dont have to adjust the setting under each app.


    Office Excel 2003 Macros menu location:
    Fig. 1



    Fig. 2
    Office Excel 2007 Ribbon bar (AKA: menus and toolbars):




    See post #2 for "How to display the Developer tab".
    Last edited by RobDog888; Dec 10th, 2006 at 02:33 AM.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Corsair H100i v2 water cooler, Geforce GTX1060, Samsung M.2 500 GB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2010, VS 2010

  2. #2

    Thread Starter
    Super Moderator RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,649

    Re: [FAQ's OD] Where did the VBA IDE go in Office 2007?

    To show the Developer tab, exposing all the usual VBA items plus more, do as follows...


    1. Click the Office icon logo at the top of any Office application to drop the menu down and click the Options button (Fig. 3).

    Fig. 3





    2. Next, under the Popular category, "Top options for working with [Office app name]" check the box for "Show developer tab in the Ribbon" (Fig. 4).

    Fig. 4





    3. Then click OK to accept and apply the change(s) and you will now see the Developer tab in the Ribbon (Fig. 5).

    Fig. 5





    4. Now in the Developer tab we can see the "Visual Basic" button along with several other buttons grouped logically. Lets click the "Visual Basic" button to drop down the menu for it (Fig. 6).






    5. Clicking the "Launch the Visual Basic editor." menu item will , of course, start and display the VBA IDE where you can write your macro code as usual.


    Last edited by RobDog888; Dec 10th, 2006 at 02:33 AM.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Corsair H100i v2 water cooler, Geforce GTX1060, Samsung M.2 500 GB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2010, VS 2010

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width