I have 2 UDF that I use in roughly 100 cells over 6 worksheets.

Originally I had Application.Volatile within the UDF's themselves, but
this made the entire workbook unresponsive whenever one value changed.
Now that I've removed it I want to add a button to one of the
worksheets with the following code

Private Sub CalculateButton_Click()
Dim evalArr() As String
Dim i As Long
evalArr = getDefinitionList("Evaluators")
For i = 1 To UBound(evalArr)
Worksheets(evalArr(i)).Calculate
Next i
End Sub

However this doesn't update the UDF's like they should.

What am I missing?

Perhaps you could post the code for your UDF. We might be able to make it
smart calc and avoid the whole button issue all together.
--
HTH...

Jim Thomlinson


"Chris" wrote:

I have 2 UDF that I use in roughly 100 cells over 6 worksheets.

Originally I had Application.Volatile within the UDF's themselves, but
this made the entire workbook unresponsive whenever one value changed.
Now that I've removed it I want to add a button to one of the
worksheets with the following code

Private Sub CalculateButton_Click()
Dim evalArr() As String
Dim i As Long
evalArr = getDefinitionList("Evaluators")
For i = 1 To UBound(evalArr)
Worksheets(evalArr(i)).Calculate
Next i
End Sub

However this doesn't update the UDF's like they should.

What am I missing?