View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Diane Meade[_2_] Diane Meade[_2_] is offline
external usenet poster
 
Posts: 2
Default Too much recalculation

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?