Where have all the windows gone?

D

Don

When programing in VBA, I use the VBA Editor screen to
show the Explorer window on the left, occupying about one
quarter of the screen and the Code Page or User Form in
the remaining space on the right.
When I reboot the PC and go to the same project, the
screens have always shown just as I left them, which I
understand is what should happen.
Now for unknown reasons, when I return, the windows I had
open are all smaller, in different places, and some are
hidden behind the Explorer window which is the only one
which stays where I left it (whether it is docked or not.)
Net result is I have to resize all windows to get started.
I've tried "repairing" Office, but it makes no difference.
Can anyone please help.
 
B

Bernie Deitrick

Don,

Try this:

You can try this to reset the windows to their default positions:

Close Excel and the VBE
Run RegEdit
Navigate to HKEY_USERS\.Default\Software\Microsoft\VBA\Office
Rename (or delete) the value Dock (e.g. ;Dock), Excel will recreate it
when it starts next time.
Close RegEdit
Open Excel and VBE, the windows are now at their default positions.

For other suggestions, Google the groups for "VBE window docking"

HTH,
Bernie
MS Excel MVP
 
D

Don

Many thanks Bernie. That worked and the windows now stay
where I put them. Saves hours!!
 
Top