View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Duplicated code window and userform window problem

1 - At the top of the Projects window, click the folder icon that has a Tool
tip of "Toggle Folders".
2 - You have all those code windows open. Close each normally.
3 - AFAIK, that is normal behaviour. There is no relationship between the
size of the userform and the size its window.

NickHK

"Zhu" wrote in message
...
Thank you so much, Jay:

1)Project Explorer: objects under the VBAproject used to be in a tree

view,
grouped by worksheets, forms, modules and class modules. But now the tree
view is gone, and all objects are are listed togather with alphabetic

order.
It is difficult to tell which is what now.

2)Code Window: There used to be only one code window shown. But now so

many
code windows are shown, and they overlap each other. I have to search and
make front the window I need to work.

3)Userform Window: Now I can drag the edge of the userform's work area and
make the work area smaller than the userform, that is to say, half of the
userform can be shadowed by its work area. But before the problem

happened,
the userform was resized when I drag the edge of its work area, and the
userform could not be shadowed by the window it resided.

Zhu


"Jay" wrote:

Hi Zhu -

I think what you're describing is normal. Each module uses its own work
area window. If you want all VB procedure code in one window, copy all

the
code to one module.

As for the UserForm design Window, you can't move the left or upper

edges of
the form itself (they're locked to the work area window), but you can

drag
the right-hand and lower edges of the form, essentially giving you total
control over its size.

I don't think your work area is broken; unless I've misunderstood you,
that's the way it's supposed to work.
--
Jay


"Zhu" wrote:

Initially, the Project Explorer and Property window can not be docked

to the
left side in the VBE. I have them fixed by deleting the code in the

Registery
Editor by running Regiedit.
But here are still some other problems: I have duplicated Code

Windows. Each
time when I click a Module, a new Code Window appears. But I just need

one.
Also, the Userform design window can not be resized togather with the
userform.
Can anybody tell me how to fix the problems?
Thanks