I've setup in several places in my file the following sheet formulas:
=HYPERLINK("#restoreDefaultForRange(rngI)","Restore defaults")
The # allows me to run the macro restoreDefaultForRange()
from the current workbook.
Inside the Macro, I have the code below that allows me to speed up the runtime:
Application.EnableEvents = False
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Application.DisplayAlerts = False
If I run restoreDefaultForRange() from VBA, everithing works fine, and the events and calculation are turned off. If I run the same macro by clicking on the Hyperlink, the code above is ignored and the macro runs super slow because Events and calculation remain ON. It's exactly the same macro, and does the same actions.
Can anyone help explain this behaviour? Is there is a way I can correct it?