Arranging VBA windows

  • Thread starter Thread starter Hari
  • Start date Start date
H

Hari

Hi,

I want to arrange the three windows in the following way:-

a) Project-VBA project --- On left top side and just big enough to view
the workbook name. Its left edge should be glues to left edge of VBA
editor
b) Properties --- Jusst below a) and the edges for each glues together.
c) VBA editor - Occupying the rest of the retail space in such a way
that its left edge is glued to a) and b) and stretches.

I understand that the above is default arrangement, but somehow I
messed it up and I just cant seem to glue c) with a) and b).

Pls note I have been able to glue together a) and b) but again these 2
somehow dont stick to the to left edge of VBA editor.

Regards,
HP
India
 
If this is the default view, you can:

Close excel
Windows start button|run
regedit
(click ok)


And then follow the instructions posted by Tom Ogilvy:

What version of excel? If Version 2002 or 2003 look for

HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common\Dock

you aren't deleting a file. You are deleting a value in the registry.
Windows/Excel will recreate it with default values which should restore the
original layout of the VBE.
 

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