Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm Toolbox displaying
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm Toolbox displaying
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm Toolbox displaying
Thanks for your help. I'll do that and see what happens. 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform with textbox displaying Cell B1 Value | Excel Discussion (Misc queries) | |||
control toolbox and userform toolbars in XL 03 | Excel Discussion (Misc queries) | |||
Userform for displaying values from a row | Excel Discussion (Misc queries) | |||
displaying picture in a userform | Excel Programming | |||
Displaying progress on UserForm | Excel Programming |