ExcelBanter - radio buttons

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - radio buttons (https://www.excelbanter.com/excel-programming/395670-radio-buttons.html)

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?

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?