Application.Volatile

[Nader]

Hello,

Is it possible to execute the volatile method like an on/off button. To
refresh the data only when I want to.
Also, can retrieve if the status of the volatile methode ?

Thank you in advance.

[Kevin B]

If you set Calculation to Manual, the F9 key will do what you're requesting
--
Kevin Backmann


"Nader" wrote:

> Hello,
>
> Is it possible to execute the volatile method like an on/off button. To
> refresh the data only when I want to.
> Also, can retrieve if the status of the volatile methode ?
>
> Thank you in advance.
>
>
>

[Nader]

it doesn't work at all.

"Kevin B" <kbackmann@sbcglobal.net.spamBgone> a écrit dans le message de
news: A9D2AFE7-A652-4A82-860C-3B20A02FB505@microsoft.com...
> If you set Calculation to Manual, the F9 key will do what you're
> requesting
> --
> Kevin Backmann
>
>
> "Nader" wrote:
>
>> Hello,
>>
>> Is it possible to execute the volatile method like an on/off button. To
>> refresh the data only when I want to.
>> Also, can retrieve if the status of the volatile methode ?
>>
>> Thank you in advance.
>>
>>
>>

[Jim Thomlinson]

Application.Volatile is not like other application level settings as it is
not a persitent setting. Primarily what it does is it tags the cell that it
is in as always being dirty (in need of a recalc). If you are using xl2002 or
better then you can manipulate the dirty setting yourself through code and
potentially eliminate the need for the volatile setting. Check out this link
for a bit more info...

http://www.decisionmodels.com/calcsecrets.htm
--
HTH...

Jim Thomlinson


"Nader" wrote:

> Hello,
>
> Is it possible to execute the volatile method like an on/off button. To
> refresh the data only when I want to.
> Also, can retrieve if the status of the volatile methode ?
>
> Thank you in advance.
>
>
>