View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Application.Volatile

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.