Schematics For A Floating Arm Trebuchet

Implementing Properties "Restore the environment VBE

First, my best wishes for 2011! A

info: Microsoft has granted me the title of MVP Excel 2011:)

And now, at work!

Suppose that by following the instructions in the previous article, although you have managed to accommodate the project explorer on the left of the window of the VBE. You are then in the following situation, where the next goal is to house the "Properties" window under that of the Project Explorer:

will hide now (right-click in the window and then "Hide") the code window, to keep only the Project Explorer and Properties window. Slightly move the properties window to the left: the border is so thick (Figure 1).

If you continue to pull the window to the left is - dotted end this time! - A vertical rectangle (Figure 2). If you release the mouse button at this point, the properties window is housed in vertical strip, to the right of the Project Explorer.

If one hand pulls the window down, you see - dotted end this time! - A horizontal rectangle (Figure 3). If you release the mouse button at this point, the properties window fits in the banner vertical in the Project Explorer.

And voila! You have managed to reconstruct the layout of the installation of VBE Excel. Suffice it now to double click on a module so it fills the right side of the VBE window.

Note - You probably already know, but I say just in case ... When it is positioned between two windows of the band left to find the resize cursor line can be up or down horizontal separation between the explorer window projects and the properties window.