Does anyone know how to detect when a UDF is being edited in the
Function Wizard? I need to know because my function takes a long time
to calculate, so I want to switch off calculation attempts until data
entry is complete. My idea is that if I know the Function Wizard is
active then I can just skip the calculation.

I have already tried looking at Application.Caller but this seems to
return a range whether in the Function Wizard or not.

You can't (to the best of my knowledge). If this is not a volitile function
then changing the calulation setting should not make a big difference to the
speed (unless you are changing the parameters of the function frequently, or
copying the function), and you would not be able to catch that anyway.
--
HTH...

Jim Thomlinson


" wrote:

Does anyone know how to detect when a UDF is being edited in the
Function Wizard? I need to know because my function takes a long time
to calculate, so I want to switch off calculation attempts until data
entry is complete. My idea is that if I know the Function Wizard is
active then I can just skip the calculation.

I have already tried looking at Application.Caller but this seems to
return a range whether in the Function Wizard or not.

Charles Williams posted a suggestion from Alex Koenig that seems to work ok:

Option Explicit
Function YourFunctionHere(whatever as whatever)

If (Not Application.CommandBars("Standard").Controls(1).En abled) Then
Exit Function
End If

'rest of function here
End Function

It looks at the toolbar to see if you're in the wizard. (Try it and you'll see
lots of icons are disabled.)

wrote:

Does anyone know how to detect when a UDF is being edited in the
Function Wizard? I need to know because my function takes a long time
to calculate, so I want to switch off calculation attempts until data
entry is complete. My idea is that if I know the Function Wizard is
active then I can just skip the calculation.

I have already tried looking at Application.Caller but this seems to
return a range whether in the Function Wizard or not.

--

Dave Peterson