Visual Basic Editor (VBE) Window

Location: http://www.mvps.org/dmcritchie/excel/vbewindow.htm      
Home page: http://www.mvps.org/dmcritchie/excel/excel.htm
[View without Frames]

Viewing the VBE Window

Hopefully, you never have to touch this.  But things suddenly got messed up and I had a lot of difficulty getting things back to how Excel had been packaged.  There is a slight improvement here in that the intermediate window is now visble if used.

To get the Project Explorer (Ctrl+R) to appear on the left side of the VBE window, and the Code (PF7) to appear on the right side of the VBE window.  Even better now if the Intermediate window (Ctrl+G) is brought up it appears across the entire bottom of the VBE window.

The Code (PF7) window if maximized will appear on the right in one place on top of other code if additional code is also open and can be exited out backing out in the order they last appeared. (Last In First Out).  Meanwhile the Project Explorer (Ctrl+R) remains in place on the left.

  1. From Excel spreadsheet invoke the VBE (Visual Basic Editor) Alt+F11
  2. Window menu, Close all Windows
  3. Tools menu, options, docking tab, [x] Immediate Window, [x] Project Explorer
  4. Ctrl+R (Project Explorer), Window menu, Tile Vertically
  5. Dock it on the left by moving the blue title bar to left side (and down) of VBE window, if not already positioned down entire left side of the VBE window.
  6. PF7 (Code), Maximize the code window.  Exit each code window individually when finished or close all windows, as they will involve additional storage requirements.

Related

  • Exporting all VBA code from the active workbook to text files. Paul Sardella, programming, 2001-05-18. (other websites to check for code or utilities for this might be Rob Bovey, Charles Williams, Chip Pearson)
    This page was introduced on March 29, 2001. 

    [My Excel Pages -- home]    [INDEX to my site and the off-site pages I reference] 
    [Site Search -- Excel]     [Go Back]    [Return to TOP] 

    Please send your comments concerning this web page to: David McRitchie mailto:DMcRitchie@msn.com.