Arranging VBA windows

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.



Hari wrote:
>
> 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

--

Dave Peterson

Dav,

Thanks for posting the solution by Tom. It works perfectly.

regards,
HP
India

Dave Peterson wrote:
> 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.
>
>
>
> Hari wrote:
> >
> > 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
>
> --
>
> Dave Peterson