option buttons' values = false
 

i have 100 option buttons on a sheet, is there a loop that can set all of
there values to False? i can't seem to get the syntax.

option buttons' values = false
 

Spencer,
try this

For i = 1 To 100
ActiveSheet.DrawingObjects("option button " & i) = False
Next i

Neil
"Spencer Hutton" wrote in message
...
i have 100 option buttons on a sheet, is there a loop that can set all of
there values to False? i can't seem to get the syntax.