Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to activate the button
Hi, I have a form button that I managed to hide with this code:
Private Sub Workbook_Open() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets With ws.Buttons(Application.Caller).Visible = False End With Next ws End Sub Now, I dunno how to ref the button I created to make it unhide. I will be making it appear in the Worksheet_change event. The button is a form button called Test -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to activate the button
Perhaps:
ws.Buttons("Test").Visible = True -- Jim Rech Excel MVP "junx13 " wrote in message ... | Hi, I have a form button that I managed to hide with this code: | | Private Sub Workbook_Open() | Dim ws As Worksheet | | For Each ws In ActiveWorkbook.Worksheets | | With ws.Buttons(Application.Caller).Visible = False | End With | Next ws | | | End Sub | | Now, I dunno how to ref the button I created to make it unhide. | | I will be making it appear in the Worksheet_change event. | | The button is a form button called Test. | | | --- | Message posted from http://www.ExcelForum.com/ | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
repost: How do I activate an option button? | Excel Discussion (Misc queries) | |||
How do I activate an option button? | Excel Discussion (Misc queries) | |||
button in a cell to activate a macro | Excel Worksheet Functions | |||
How do I activate right mouse button in Excel | Setting up and Configuration of Excel | |||
activate a worksheet formula through a button | Excel Discussion (Misc queries) |