Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
BUTTONS
I know how to assign a button to a macro. My question is:
How can I make that Buttom hide until a particular cell result is true. Thanks, Glenn |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
BUTTONS
Hi Glenn,
Use something like this ... Option Explicit Option Compare Text Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub If Target.Address = "$A$1" Then '<<== CHANGE! Application.EnableEvents = False If Target.Value = "True" Then Shapes("Button 1").Visible = True '<< CHANGE! Else Shapes("Button 1").Visible = False'<< CHANGE! End If Application.EnableEvents = True End If End Sub To install: Right click sheet tab (name) Select View Code Paste on right Change Button name (2 places) Change Target Address (from A1) Alt + Q returns to Excel SAVE FIRST! -- Regards, Zack Barresse, aka firefytr "Glenn" wrote in message ... I know how to assign a button to a macro. My question is: How can I make that Buttom hide until a particular cell result is true. Thanks, Glenn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option Buttons/Radio Buttons | New Users to Excel | |||
Form buttons vs. ActiveX Buttons | Excel Discussion (Misc queries) | |||
have toggle buttons but everytime print preview buttons move | Excel Discussion (Misc queries) | |||
pivot chart is it possible to hide individual field buttons? Layout Field buttons | Charts and Charting in Excel | |||
Control Buttons vs. Command Buttons | Excel Programming |