Results 1 to 7 of 7

Excel 2007 - right-click, View code

This is a discussion on Excel 2007 - right-click, View code within the Excel Questions forums, part of the Question Forums category; In previous versions of Excel, you were able to right-click the XL icon in the top-left of the screen and ...

  1. #1
    Board Regular
    Join Date
    Jun 2005
    Location
    London
    Posts
    6,330

    Default Excel 2007 - right-click, View code

    In previous versions of Excel, you were able to right-click the XL icon in the top-left of the screen and select 'View Code' to be taken to the 'This Workbook' module. Now that the XL icon has been replaced by the Office button, I can't find an alternative method.

    Yes I know there are other methods of accessing the VBA IDE (Alt+F11 or Developer tab>Visual Basic, or right-clicking a sheet tab), but if my mouse was already in the top-left of the screen, it was a useful shortcut.

    Has anyone discovered a different shortcut to a workbook's code?
    Neil

  2. #2
    Board Regular
    Join Date
    Feb 2004
    Posts
    143

    Default Re: Excel 2007 - right-click, View code

    I just got 2007 yesterday and it took me forever to figure out how to print. But in the process i found the VB icon the Developers Tab, which had to be added by cliking on Microsoft Office Button|Excel Options|Popular|Show Developer Tab in Ribbon (its a checkbox). Happy Hunting....

  3. #3
    Board Regular
    Join Date
    May 2003
    Location
    Katy, Texas
    Posts
    3,829

    Default Re: Excel 2007 - right-click, View code

    Perhaps the method I usually use in Excel 97 will work for you? Try right clicking on the sheet's tab, then selecting View Code.
    Ralph A. Esquivel, Excel 97 SR2 (Ver. 8.0), Windows XP, Home Edition, Service Pack 2, HP LaserJet 4L printer.

  4. #4
    Board Regular
    Join Date
    Jun 2005
    Location
    London
    Posts
    6,330

    Default Re: Excel 2007 - right-click, View code

    Thanks to both of you, but the doesn't help if the Home tab is displayed and my mouse is in the top-left of the screen.

    Oh well, guess I'll have to get used to this additional 'feature' of the Ribbon!
    Neil

  5. #5
    MrExcel MVP
    Join Date
    Apr 2006
    Posts
    15,249

    Default Re: Excel 2007 - right-click, View code

    Hi Neil

    The View Code button was the first one I added to the Quick Access Toolbar (soon followed by the Print and Print Preview buttons). It's the small command bar that is at the top left of the window, to the right of the Excel button. You may place it below the ribbon if you prefer.
    Kind regards
    PGC

    To understand recursion, you must understand recursion.

  6. #6
    Board Regular
    Join Date
    Jun 2005
    Location
    London
    Posts
    6,330

    Default Re: Excel 2007 - right-click, View code

    Thanks pgc

    I've already added most of the buttons I use regularly to the QAT, but it hadn't occured to me to add the View Code button.

    It's just a shame the icons on the QAT are so small. More than once, I've accidentally saved the file I was working in without meaning to, by clicking the wrong button!
    Neil

  7. #7
    MrExcel MVP
    Join Date
    Apr 2006
    Posts
    15,249

    Default Re: Excel 2007 - right-click, View code

    I've accidentally saved the file I was working in without meaning to, by clicking the wrong button!
    Yes, I also was afraid of that, and so I changed the layout and now I have the first 2 buttons, New and Save, then I inserted 2 separators, and then all the other buttons. This way I don't feel any danger when I click the Save button.
    Kind regards
    PGC

    To understand recursion, you must understand recursion.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com