Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Zhu Zhu is offline
external usenet poster
 
Posts: 5
Default Duplicated code window and userform window problem

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

  #2   Report Post  
Posted to microsoft.public.excel.programming
Jay Jay is offline
external usenet poster
 
Posts: 671
Default Duplicated code window and userform window problem

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

  #3   Report Post  
Posted to microsoft.public.excel.programming
Zhu Zhu is offline
external usenet poster
 
Posts: 5
Default Duplicated code window and userform window problem

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

  #4   Report Post  
Posted to microsoft.public.excel.programming
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
View cell contents as a pop-up window (similar to comments window) Oldersox Excel Worksheet Functions 1 February 6th 08 07:09 AM
VBA line of code executes in Immediate Window but not in Code Window [email protected] Excel Discussion (Misc queries) 2 April 30th 07 02:52 PM
Docking Project Explorer, Properties window and Code window in VBE jayray Setting up and Configuration of Excel 2 March 27th 07 04:42 PM
The window opens in a smaller window not full sized window. Rachael Excel Discussion (Misc queries) 0 November 7th 06 09:04 PM
Immediate Window not showing up below code window ExcelMonkey Excel Programming 1 March 22nd 06 12:02 AM


All times are GMT +1. The time now is 01:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"