Connecting Tech Pros Worldwide Help | Site Map

Application.ScreenUpdating =

Newbie
 
Join Date: Aug 2007
Posts: 2
#1: Aug 29 '07
False does not work when my VB sub updates a worksheet that is not active - the screen flashes.

All of the examples of Application.ScreenUpdating I have seen (here and elsewhere) are updating the active sheet. My sub updates a sheet named "Dock_Diagram" based on a worksheet change to a sheet named "Names". The code works but the screen flashes during the update. Additional info:

- using Excel 2000
- the changes to the Dock_Diagram are setting the Interior.ColorIndex and Interior.Pattern of a range of cells.

Any assistance will be greatly appreciated.
Reply