| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
add + suppress command buttons in execution time
Hi all,
I have wrote an Excel VBA Macro in witch I have a userform with too many controls(commandbuttons, togglebuttons, etc.). I want to dynamically create and suppress at least 4 of the commandbuttons in the execution time. Does someone have any idea? Thanks for all. Ali |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
add + suppress command buttons in execution time
You can just set teh enabled property to false to graey out the buttons or
you can set the visible property to false... CommandButton1.Visible = false CommandButton2.Enabled = False -- HTH... Jim Thomlinson "Ali Couran KOTE" wrote: Hi all, I have wrote an Excel VBA Macro in witch I have a userform with too many controls(commandbuttons, togglebuttons, etc.). I want to dynamically create and suppress at least 4 of the commandbuttons in the execution time. Does someone have any idea? Thanks for all. Ali |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I suppress the time in m/d/yy date column? | Excel Discussion (Misc queries) | |||
| Suppress dialog from regserver command | Excel Discussion (Misc queries) | |||
| Command Button Macro Execution Failure | Excel Programming | |||
| Control Buttons vs. Command Buttons | Excel Programming | |||
| How to suppress Time ? | Excel Programming | |||
Hybrid Mode
