Hi there,

Not sure i totally understand what you are asking, is it that you
simply do not want the result of the check box to be recorded in your
worksheet?

If this is the case then simply right-click on the checkbox and select
format_control.. then delete anything that is in the cell link box.
Doing this will ensure that if anyone tries to check the box the
results will not be recorded.

If however you simply do not want them to be able to select the
checkbox, you could simply draw a box the same shape as the check box
and position it on top of the checkbox. If you format the box so that
there is no fill and no lines then it will appear invisible.(remember
the box need to be on top of the check box)

I Hope this helps you, if this is not quite what you meant then please
let me know

Best regards,

Rob Turnbull
*Sortoutmyexcel.com*


--
Rob Turnbull
------------------------------------------------------------------------
Rob Turnbull's Profile: http://www.excelforum.com/member.php...o&userid=24278
View this thread: http://www.excelforum.com/showthread...hreadid=380216