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?
>
>