Option buttons - disabling

[Ann]

Hi
is it possible to disable option buttons on a sheet (not a
user form) eg: I have two sets of option buttons - what I
want to do is if the user clicks on one set then the other
set becomes greyed out and disabled and vice versa - I
found out from a very helpful person how to do this on a
form but my job does not want me to do this on a form but
on a normal sheet with option buttons.
Please help.

 

[Chip Pearson]

Ann,

You can disable an option button from the Forms command bar with
code like

Dim WS As Worksheet
Set WS = ActiveSheet
WS.OptionButtons(1).Enabled = False


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)