Hi

I have been using form option buttons rather than the ones from the command
toolbox as they have a better appearance on the screen.

The option buttons are not locked because I use the macro to clear them all
when the sheet gets used again.

Private Sub clear_Click()
Worksheets("sheet1").CheckBoxes.Value = xlOff
Worksheets("sheet1").OptionButtons.Value = xlOff
End Sub


If I lock the option buttons I get an run time error on running the macro!

But if I don't lock the option buttons you can still right mouse and select
them, which is also true for the forms checkbox.

I like to use the forms option buttons as the sheet gets printed and these
buttons look better compared to the option buttons from the command toolbox.

Is there a way to modify the macro so that it will work when the option
buttons are locked?

Hope that makes sense.
--
This post was created using recycled electrons!