_Change still would have nothing to do with the issue. Clicking on a hyperlink is not a change. A formula calculation is not a change, though it can be caused by a change in another precedent cell but maybe on a different sheet, so since the result needing to trigger a macro is formula-driven, a Calc event in the sheet module would be the safer bet given the choice between Change and Calc.