There is no way of avoiding the recalculations, except by changing to Manual
rather than automatic calculation mode.

Look at http://www.DecisionModels.com/calcsecretsj.htm for some ideas on
speeding up UDFs.

Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com

"MJ" wrote in message
...
My user defined function often take several second to complete.
When hiding some rows or column or when hiding in a list, Excel triggeres
a
recalculation.
This is bad luck for me.
Would you know if there is way to avoid that?

Thanks,

Michel