Option buttons - disabling

  • Thread starter Thread starter Ann
  • Start date Start date
A

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.
 
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)
 
Back
Top