<<I think all service packs are installed, Version Microsoft Excel 2000
(9.0.3821 SR-1).

You may not have all service packs installed. I also use Excel 2000, and
mine is at 9.0.6926 SP-3. For details about SP-3, see
http://www.microsoft.com/downloads/d...displaylang=en
I am not sure what the difference between a Service Release (SR) and a
Service Pack (SP) is, unless Microsoft has simply changed the way they name
their updates.

<<I am using the ActiveX Checkbox. I each time copy a formula (the same) in
the linked cell, however, the value does not change because of this. I need
to copy this formula each time, otherwise the ranges do change. However, how
does this effect the controll of the checkboxes?

This may be the problem. You should NOT be storing a formula in the linked
cell, because then Excel will use the formula to overwrite the value written
by the checkbox the next time that the worksheet is recalculated. If you
have a macro that is constantly restoring the formula in the linked cell,
then your checkbox effectively has no control! My tests bear this out.

The checkbox should simply save the value (TRUE or FALSE or #N/A!, if it is
a tri-state checkbox) to the linked cell on the same worksheet that contains
the checkbox. Your worksheet should then use this value to do whatever it is
going to do with the checkbox value. If you are only using the ActiveX style
checkbox to run event handlers to carry out actions, then leave the Linked
Cell property blank and just use the Value property of the checkbox.
--
Regards,
Bill