I'm looking to insert two check boxes into a spreadsheet so when I send the
worksheet to someone else they can click the one that applys. I'd also like
to have it set-up so that when one box is selected the other cannot be.

thanks.

Using the tools on the Forms Toolbar you'll find that Option Buttons will
automatically exhibit that behavior. Check Boxes aren't designed to work
that way, nor do they have any property setting to change their behavior. If
you insist on using check boxes I assume there would have to be some
underlying VBA to make them mutually exclusive.
--
HTH |:)
Bob Jones
[MVP] Office:Mac

"
wrote in message ...
I'm looking to insert two check boxes into a spreadsheet so when I send
the
worksheet to someone else they can click the one that applys. I'd also
like
to have it set-up so that when one box is selected the other cannot be.

thanks.

Sorry - I didn't specify exactly what i need. I am going to have a list of
customer (x amount of rows) and for each customer (row), they are going to be
two options to the right - each option will have an option button (one in
column e and one in f). When I send this list to the customers I'd like to
have two functionalities with the buttons:: (1) make it so that if they
choose the option in column E, you can't choose the option in column F and
vice versa - and have this apply to each row individually. Right now i can
click on one option button no matter where its placed.
(2) place a select all button at the top of row E and F so if you click that
button, it will automatically select all the option buttons in that column .

Can this be done?

"CyberTaz" wrote:

Using the tools on the Forms Toolbar you'll find that Option Buttons will
automatically exhibit that behavior. Check Boxes aren't designed to work
that way, nor do they have any property setting to change their behavior. If
you insist on using check boxes I assume there would have to be some
underlying VBA to make them mutually exclusive.
--
HTH |:)
Bob Jones
[MVP] Office:Mac

"
wrote in message ...
I'm looking to insert two check boxes into a spreadsheet so when I send
the
worksheet to someone else they can click the one that applys. I'd also
like
to have it set-up so that when one box is selected the other cannot be.

thanks.