How to prevent window flickering/switching in Excel?

Question

I am copying from one file to an other file, and I can see Excel switching between the source and the target file (like flickering). I want the macro to copy from the source and paste to target WITHOUT switching between the files (I DON'T want flickering). So here I got my Excel VBA code. I set up a Button to run 2 macros. The first macro is an openfiledialog where I can choose a file to be opened. That is required because the needed file always got a different name and is in a different path. After opening the file my second macro starts (CopyPasteValues), the one I posted below. At first I set my source and target Workbooks/Worksheets and create an array with 16 account numbers. Then I use the find method to search for the account number in each file (source and target). The result of the find method is used to create an offset in the src file and copy it to an offset in the target file. ``` Sub CopyPasteValues() Dim srcWb As Workbook 'source Wb Dim srcWs As Worksheet 'source Ws Dim…

Accepted Answer

(Answered in comments by Andy G):

Use `Application.ScreenUpdating = False` at the start of your sub. Remember to set it back to `True` at the end (also good practice to do this in an error handler so it gets reset even in the event of an error):

```
Sub foo()
  On Error Goto errHandler
  Application.ScreenUpdating = False

'Your code here

Application.ScreenUpdating = True
errHandler:
  Application.ScreenUpdating = True
End Sub
```

How to prevent window flickering/switching in Excel?

Solution

Problem