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.