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 |
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) |