The only way to do that would be to put in an argument that tells
the UDF to return some value (e.g., #NA or 0 or "") without doing
the real calculation.


Public Function MyUDF(<your regular arguments, _
Optional NoCalc As Boolean = False)
If NoCalc = True Then
MyUDF = CVErr(xlErrNA)
Exit Function
End If
' rest of your code
End Function


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"masterphilch" wrote in message
...
Hi

I did some UDF on a worksheet. In some cases, I want to prevent
executing the UDF, even if an argument changed. This, just
because some processec take too much time. Is that possible?

thanks a lot for help

masterphilch