hi again
forgot about part 2. opps.
I know how to hassel a used with a form in access but i'm
not that up to excel forms. i have played with them but
just play. I personally know of no way to make user input
mandatory on a spreadsheet. sorry.

-----Original Message-----
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
.

.