View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach[_6_] Otto Moehrbach[_6_] is offline
external usenet poster
 
Posts: 201
Default UserForm Toolbox displaying

I tried what you said and it worked. Thanks again. Otto
"keepITcool" wrote in message
...

i've seen this happen to me too :(

i think it's a bug.

open all forms in designmode and make sure the control toolbox is NOT
displayed. close the forms. save the xls or xla.

in one of my addins I've even had to include it in
my SaveForProduction routine.


For Each wnd In Application.VBE.Windows
If wnd.WindowState = 2 Then wnd.WindowState = 0
If wnd.Type <= 1 Or wnd.Type = 10 Then wnd.Close
Next



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Otto Moehrbach wrote :

Excel 2002, WinXP
When I am building a UserForm the VBE displays a small square
toolbox. I am calling that toolbox the UserForm Toolbox for purposes
of this message. My scenario is not in the VBE.
I have a workbook sheet on the screen.
I have a user-built menu.
I click on one of the menu items.
Nothing in my code refers back to the VBE.
When the code starts executing, the UserForm Toolbox is displayed on
the screen as well as the progress UserForm I would expect. This
UserForm displays a moving bar as the code progresses.
The UserForm and toolbox appear only for a split second because, for
development purposes, I am using only a very small piece of data on
which the code acts.

My question is:
Why does the toolbar appear?
Thanks for your help. Otto