Option controls should be 'grouped' so only 1 can be selected; -clicking on any
button in the group deselects the others. Grouping requires using ActiveX
controls!

Also, best to put controls at the top of the sheet in non-scrolling rows so
they don't shift around (lose position) when hiding/unhiding cols/rows.

Optionally, you could use a modeless userform setup so it's 'context sensitive'
to what the user is doing so it only exposes controls that suit the activity at
hand.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion