| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Show Command Buttons
I am hiding a command button(s) with the following statement
CommandButton1.Visible = False I then need to display all of the buttons on the page. I had tried: Application.CommandBars("Control Toolbox").Controls("&Design Mode").Execute CommandButton1.Visible = True But that didn't work. Thanks in advance for any help. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide Show Command Buttons
See this page for a example
http://www.rondebruin.nl/controlsobjectsworksheet.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Troubled User" wrote in message ... I am hiding a command button(s) with the following statement CommandButton1.Visible = False I then need to display all of the buttons on the page. I had tried: Application.CommandBars("Control Toolbox").Controls("&Design Mode").Execute CommandButton1.Visible = True But that didn't work. Thanks in advance for any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Hide Form and Command Buttons until such condition is true? | Excel Discussion (Misc queries) | |||
| Command Button to show/hide a different worksheet | Excel Discussion (Misc queries) | |||
| How do I get Excel 2000 command buttons to show in Excel 2003? | Excel Discussion (Misc queries) | |||
| How do I hide 5 command buttons | Excel Programming | |||
| Control Buttons vs. Command Buttons | Excel Programming | |||
Linear Mode
