UDF called from Wizard

[macleanb]

Hi Guys

I have a series of VBA UDF's that are reasonably long running - and I dont want them to perform their normal calcs when called from the Function Wizard dialog.

My basic question is - how can I tell if the VBA UDF has been called from the wizard (without resorting to a C++ based addin)


ttfn benm

 

[Sandeep Warrier]

One way would be.... you could probably include a message box with Yes/No options and depending on the option selected set calculation to manual or automatic....
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">