hi,
you will need to use this code. right click each check box
and click view code.
but this sub behind check box 1
Private Sub CheckBox1_Click()
If CheckBox1 = True Then
CheckBox2 = False
End If
End Sub
put this code behind check box 2
Private Sub CheckBox2_Click()
If CheckBox2 = True Then
CheckBox1 = False
End If
End Sub
regards

-----Original Message-----
I have 2 questions;
1. I have added check box's e.g Yes No onto a spreadsheet
but you can tick
both of these. What i am after is to only be able to tick
one or the other
but not both. Can anyone help?
2. I need to make some parts of my spreadsheet mandatory
but i have no idea
on how to do this??? I been through the help files but
can not find anything
about this. Help on this would be great. Thanks
.