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.
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.