Unanswered: VB macros and form objects (e.g., OptionButton) how to disable?
Thanks for looking at this.
My question is, once I have some option buttons (radio buttons) created in my sheet, within a group object, how can I use a macro to disable them? More particularily, I have one set of option buttons that, once selected, will disable another set.
Here's what I've tried. I have a macro created:
OptionButton1.TripleState = False
I read that the triplestate property will shade or disable the button. Is that not correct?
Does anyone have any other ideas how I could do this?