In many of my Excel applications, I am using user-defined-functions that take quite a long time to calculate. (several seconds)
Therefore, I like to avoid any useless recalculation.
On the other side, rather large tables are involved and it is very convenient to hide or show rows or columns depending on the needs.

Bad luck!
Hiding or showing rows or columns triggers a recalculation!

Would there be any way to avoid this recalculations?
In my applications, the results of the calculations do not depend of the visibility of any cell, so this recalculation is really useless.

Is there a way to

1) detect (in the SheetCalculate event) that a recalculation is useless
2) cancel the recalculation