Excel followhyperlink method - screen flickering

On a main spreadsheet I'm using a vba Loop code to open spreadsheets files by using the followHyperlink method. Once a file is opened, I use another loop to check a range, cell by cell, for data. If the cell has data them before copying and pasting it in the main spreadsheet, I make sure that the cell destination is empty to avoid data override. The code works fine but the screen flicks non stop. I'm using:

application.ScreenUpdating = False
application.DisplayAlerts = False

As well as DoEvents, but the flickering didn't stop.

Any suggestions? Thanks

https://stackoverflow.com/questions/65963664/excel-followhyperlink-method-screen-flickering January 30, 2021 at 09:05AM