VBE and Arranging Windows

[Bishop]

Is there a way to arrange my VBE and the spreadsheet I'm working on side by
side so that I can see my code and the active spreadsheet at the same time?
I do this manually at the moment but was wondering if there was an "Arrange
All" similar function that applied to VBE.

Thanks

 

[MichDenis]

Hi Bishop,

Close all instances of Excel

Open the Regedit Window

You go to :
HKEY_USERS\S-1-5-21-1957994488-492894223-839522115-1003
\Software\Microsoft\VBA\6.0\Common

This serie of number may be different on your machine
57994488-492894223-839522115-1003

and you suppress ONLY this key : "Dock"

Close the window et re-open Excel.




"Bishop" <[email protected]> a écrit dans le message de groupe de
discussion : (e-mail address removed)...
Is there a way to arrange my VBE and the spreadsheet I'm working on side by
side so that I can see my code and the active spreadsheet at the same time?
I do this manually at the moment but was wondering if there was an "Arrange
All" similar function that applied to VBE.

Thanks

 

[Dave Peterson]

Treat them like separate applications.

Minimize all other windows (except for the Excel window and the VBE window).

Then rightclick on an empty spot on the windows taskbar (usually at the bottom
of the screen).

Choose Tile windows (horizontally or vertically)
or cascade

Or just make them more than minimized, but less than full screen and arrange
them the way you like.

========
Or it maybe time to invest in new hardware (a new monitor and maybe a
new/secondary video card???).

If you're using multiple monitors, you may want to review Chip Pearson's notes:
http://cpearson.com/excel/MultipleMonitors.aspx