View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Nader Nader is offline
external usenet poster
 
Posts: 44
Default Application.Volatile

it doesn't work at all.

"Kevin B" a écrit dans le message de
news: ...
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.