ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   what is happening whit my controls (https://www.excelbanter.com/excel-programming/346526-what-happening-whit-my-controls.html)

filo666

what is happening whit my controls
 
Hi, I have a workbook with a autoopen procedure, this procedure among all the
actions it does, hide all the toolbars:
a = False
With Application
.CommandBars("Programa 2").Enabled = a
.CommandBars("Analisis").Enabled = a
.CommandBars("Programa").Enabled = a
.CommandBars("Worksheet Menu Bar").Enabled = a
€˜And so on
End with

In Worksheet €œRegistroVenta€ I have 2 comboboxes and one button (the tree of
them of control toolbox menu bar), my problem is when trying to use one of
the comboboxes or the button a grey rectangle appears at the top of my screen
(the space is where all the menu bars should go) but empty, and it appears
over the page so the top part of the page (where I have important
information) isnt showed, this happens just with the controls that I use
from the control toolbox, with the controls of forms menu bar this isnt
happens and is imperative for me to use the controls from the control toolbox.
What is happening
ANY SUGGESTIONS???
TIA



All times are GMT +1. The time now is 11:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com