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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 06:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com