Video chat 18sex - Screen updating excel

When I format the axes or data series, Excel automatically updates the chart before I am finished editing the value.

This is very slow (1 minutes), even with my 3.30-GHz, 8-core, Windows 7 Enterprise machine with 8-GB of memory.

' This includes both posting free demo projects made from this ' code as well as reproducing the code in text or html format.

' --------------------------------------------------------------------------------' User Defined Error codes Const ERR_NO_WINDOW_HANDLE As Long = 1000 Const ERR_WINDOW_LOCK_FAIL As Long = 1001 Const ERR_VERSION_NOT_SUPPORTED As Long = 1002 ' API declarations for Find Window() & Lock Window Update() ' Use Find Window API to locate the Power Point handle.

For example, if I want to change the line width from 2.25 to 1.5, every time I type or delete something, the chart updates.

Is there a way to disable screen updating while reformatting the Excel 2007 chart?

Excel & Word have the Screen Updating method thru which a developer can lock the main window from unnecessarily redrawing itself whilst the macro is being executed. If left alone, redrawing is not only ugly on the eyes it also takes more time for the macro to reach completion.

Last modified 03-Apr-2020 16:47