Change OptionButton true/false status on all sheets
Did you find the sheet that didn't have it/them?
If the names are wrong, then you may not end up with what you want.
But if you don't care, you can just do the work and ignore any error.
Sub SelectSW3()
Dim s As Long
For s = 2 To ActiveWorkbook.Sheets.Count
With Worksheets(s)
on error resume next
.OptionButton1.Value = False
.OptionButton2.Value = False
.OptionButton3.Value = True
on error goto 0
End With
Next s
Beep
End Sub
Fan924 wrote:
Can I test for the presents of OptionButton1, OptionButton2, and
OptionButton3 on each sheet so I can skip that sheet and go to the
next?
--
Dave Peterson
|