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:
Sub NewTitleClicked()
OptionButton1.TripleState = False
End Sub

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?