| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do you hide a forms command button
I need to be able to hide and display a command button depending on the
occurrence of certain events. What code can I use to hide and display a command button named "cmdEnterData"? Thank you in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do you hide a forms command button
This is from the Forms toolbar?
Worksheets("Sheet1").Buttons("cmdEnterData").Visib le = True There's another property that you might like, too: .enabled = True/False The button will still be there, but won't do anything if you click it. Paul James wrote: I need to be able to hide and display a command button depending on the occurrence of certain events. What code can I use to hide and display a command button named "cmdEnterData"? Thank you in advance. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do you hide a forms command button
sorry, missed the button is on the worksheet and not a
userform... -----Original Message----- This is from the Forms toolbar? Worksheets("Sheet1").Buttons("cmdEnterData").Visi ble = True There's another property that you might like, too: .enabled = True/False The button will still be there, but won't do anything if you click it. Paul James wrote: I need to be able to hide and display a command button depending on the occurrence of certain events. What code can I use to hide and display a command button named "cmdEnterData"? Thank you in advance. -- Dave Peterson . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do you hide a forms command button
If ??? True Then cmdEnterData.Visible = True Else cmdEnterData.Visible = False End If Hope this helps... -----Original Message----- I need to be able to hide and display a command button depending on the occurrence of certain events. What code can I use to hide and display a command button named "cmdEnterData"? Thank you in advance. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forms Command Button - Removal | Excel Discussion (Misc queries) | |||
| Use of Forms Command-button on Worksheet | Excel Discussion (Misc queries) | |||
| Command button on forms | Excel Discussion (Misc queries) | |||
| Command Button to Hide/Unhide Rows | Excel Discussion (Misc queries) | |||
| Hide command button on worksheet | Excel Programming | |||
![Paul James[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
