In a worksheet I have several user written functions. Several cells are using
this functions. If something is wrong, I get the same error message a number
of times. I want to suppress this, or stopp the recalculation from VBA
programming when the first error occurs.

My first alternative would be to suppress the message. But to do this, I
need to set a global flag that tells the program later that the error message
is shown. But when do I reset the flag from the beginning of the
recalculation?

To stopp the recalculation of the coming cells that need to bee recalculated
using the same function, I need to stop recalculating over all. How can this
be done?

In my excel worksheet, it seems that all my user written functions are
recalculated, even when the criteria of some of them is not changed. Can I do
somethinge to only recalulate those user written functions in cells where
criterias are affected by changes?

Regards DagL