Enabling and disabling option buttons in Excel using macros
Posted on 2003-11-04
I'm working with an excel 2002 file and I have a combo box and some option buttons. Depending on the choice in the combo I have to enable/disable some of the option buttons.
I began programming the macro for the OnChange event of the combo but I need to know which is the piece of code to do that, because the sentence
Worksheets(name).OptionButton1.Enable = True (Or false)
I also think about hide the rows containing the option buttons I have to disable but the problem is that the rows dissapeared but the objects (I mean the option buttons) stay together in a row so that's why I'm trying to disable them.
Any solution or another suggestion will be good!
Thanks in advance.