Where have all the windows gone?

  • Thread starter Thread starter Don
  • Start date Start date
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.
 
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
 
Many thanks Bernie. That worked and the windows now stay
where I put them. Saves hours!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top