View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan Greenwood[_2_] Alan Greenwood[_2_] is offline
external usenet poster
 
Posts: 2
Default Delay Visible Updates??

I have an Excel 2000 spreadsheet which updates itself from the textual
contents of a large number of files at startup. The updating consists
of altering a large number of strings and also a large number of cell
colours. Because of this there is a lot of flickering going on and I
was wondering if there was a way of putting visible updates on hold
temporarily (while the process continues in the background) and then
doing the whole lot in one fell swoop once the content update is
complete.

Thanks a lot in advance to anyone who can help.

--------------------------------------------------------------
Do NOT reply to the email address in the headers. It is a fake
address for trapping spam: if you want to reply to this
message, please post to the newsgroup.
------------------------------------------------------------