| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop Refreshing via VBA
G'day there John V,
I've never needed to interrupt auto-refresh myself, but your question raised my interest so I had a quick browse of XL's Help pages. There are several methods & properties to control the auto-refresh including CancelRefresh; RefreshAll; EnableRefresh; and probably of more use is the RefreshPeriod property. I'm sure you could construct somethnig to turn it on & off especially with the latter. Help gives as a description: ------ Setting the period to 0 (zero) disables automatic timed refreshes and is equivalent to setting this property to Null. The value of the RefreshPeriod property can be an integer from 0 through 32767. ----- I think that may be worth looking at. See ya Ken McLennan Qld Australia |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop Refreshing/Blinking Chart screen when running Mouse over even | Excel Programming | |||
| Stop automatic data reformat when refreshing a query | Excel Discussion (Misc queries) | |||
| How do I stop the SQL Login screen when refreshing a query. | Excel Programming | |||
| How can I stop charts from refreshing when changing source data? | Charts and Charting in Excel | |||
| How do I stop other circles in other boxes to stop selecting? | Excel Worksheet Functions | |||
Threaded Mode
