Mr. Tom Ogilvy,

Thank you very much indeed for responding to the query.

Upon altering the value of the cells, the corresponding CheckBoxes
should be updated automatically ; however, the worksheet calculation
mode is set to Mannual (for obvious reason).

When ActiveSheet.Calculate is applied,
the CheckBoxes will be updated and so will the re-calculations of a
relatively large collection of (HyperLink) formulae thereof.

As it turns out, the HyperLinks would not require re-calculations (and
hence, it should be profitable to save the noticeable time delay
expended on the non-essential activity).

Attempted but in vain, to effect a local calculation of,
ActiveSheet.Range("A1:A100").Calculate
(to which the CheckBoxes are linked and residing),
(contrary to such claims with reference to MS-Help ; sigh).

Please extend your recommendation with further move next.

Regards.