I know from my C++ windows coding there is a concept of -Update Region-
where I can essentially turn off updating the screen until I tell i
to.

When I want to do is stop the (imho) ugly way a sheet updates as
calculation is in process. My application reads a bunch-o-data from
couple of external data sources, then weeds through and consolidate
parts of the information, puts that information into a table or two an
charts it.

The problem is as the weeding, consolidating and chartings procedure
are running, the screen is performing a live update of the tables an
charts. You see the table being filled and the chart series bein
added. Not too professional looking.

What I'd like is to disable the update region for the sheet, wait fo
the process to complete, then enable the update the region and have th
sheet update in a single vertical retrace.

Possible? Anyone know how to accomplish this

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com