Application.ScreenUpdating =

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ArtVandolay
    New Member
    • Aug 2007
    • 2

    Application.ScreenUpdating =

    False does not work when my VB sub updates a worksheet that is not active - the screen flashes.

    All of the examples of Application.Scr eenUpdating I have seen (here and elsewhere) are updating the active sheet. My sub updates a sheet named "Dock_Diagr am" 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.ColorI ndex and Interior.Patter n of a range of cells.

    Any assistance will be greatly appreciated.
Working...