| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide commandbutton?
I have a commandbutton on my worksheet titled menu. When pressed a userform
appears. How do i get the commandbutton to disappear when the userform appears and reappear when the userform is closed. -- capt |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide commandbutton?
Commandbutton#.Visible = False (Hide)
Worksheets("sheetname").Commandbutton#.Visible = True (Display) Change the # to the numeric value of the commandbutton. Place the FALSE code in the routine that is executed when the command button is clicked. It is necessary to address the sheet that the commandbutton is on within the "display" code since you are using a userform. Place this code within the routine that is executed to end the userform, ie FINISNED, END, CANCEL, etc. Les "capt" wrote: I have a commandbutton on my worksheet titled menu. When pressed a userform appears. How do i get the commandbutton to disappear when the userform appears and reappear when the userform is closed. -- capt |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide commandbutton?
WLMPilot,
From one Pilot to another!!! Many thanks, it works well. -- capt "WLMPilot" wrote: Commandbutton#.Visible = False (Hide) Worksheets("sheetname").Commandbutton#.Visible = True (Display) Change the # to the numeric value of the commandbutton. Place the FALSE code in the routine that is executed when the command button is clicked. It is necessary to address the sheet that the commandbutton is on within the "display" code since you are using a userform. Place this code within the routine that is executed to end the userform, ie FINISNED, END, CANCEL, etc. Les "capt" wrote: I have a commandbutton on my worksheet titled menu. When pressed a userform appears. How do i get the commandbutton to disappear when the userform appears and reappear when the userform is closed. -- capt |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i make a commandbutton run a macro?? | New Users to Excel | |||
| Floating CommandButton | Excel Worksheet Functions | |||
| Tooltip for my CommandButton | Excel Discussion (Misc queries) | |||
| CommandButton - Userform | Excel Discussion (Misc queries) | |||
| Assigning a Hyperlink to a CommandButton | Excel Discussion (Misc queries) | |||
Hybrid Mode
