Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have two radio button on a worksheet that I need to hide based on the value
of one of my cells. Right now I hide several rows based on this cell's value but the radio buttons thta are positioned within that range of rows also need ot be hidden. Here is how I'm hiding the rows: Rows("29:40").Select Selection.EntireRow.Hidden = False Is there a way to also hide those radio buttons? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Try following:
ActiveSheet.OptionButtons("Option Button 2").Visible = False Regards reklamo "hshayhorn" wrote: I have two radio button on a worksheet that I need to hide based on the value of one of my cells. Right now I hide several rows based on this cell's value but the radio buttons thta are positioned within that range of rows also need ot be hidden. Here is how I'm hiding the rows: Rows("29:40").Select Selection.EntireRow.Hidden = False Is there a way to also hide those radio buttons? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Radio Buttons | Excel Discussion (Misc queries) | |||
Radio buttons | Excel Discussion (Misc queries) | |||
Option Buttons/Radio Buttons | New Users to Excel | |||
Radio Buttons | Excel Programming | |||
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True | Excel Worksheet Functions |