Hi
you may post your function but normally removing the line
application.volatile should do (depending on your function parameters)

--
Regards
Frank Kabel
Frankfurt, Germany


Diane Meade wrote:
I have written several custom functions for a worksheet.
I don't want these functions to recalculate every time.
I only want a recalculation when the referenced cells
change. In my functions, I put the line:

Application.Volatile (False)

But when I run my code, even if the code is not
activating the worksheets with the custom functions, the
functions insist on recalculating. Is there any way I
can stop this?