enable certain combo buttons based on user selected option buttons

hi,

I have enclosed a file as well.

i have a worksheet which contains over a hundred option buttons.

Also, on this worksheet are a 3 combo buttons and a text box.

I want to enable and/or disable the combo buttons / text box based on what option button is selected.

The only way i know to do this is to put code in each option button click event.......is there a better way?