Problem with "Application.ScreenUpdating = False" when vba adresses several wb's

[kit99]

In this thread:
https://www.mrexcel.com/forum/excel...excel-2016-screen-flickering.html#post5049484
... I was given the advice to use Application.ScreenUpdating = False on my entire code to prevent screen flashing/flickering while running the code (this issue started when upgrading from Office 2010 to Office 2016).

But my code opens and closes a lot of wb's during it's run, and I've now discovered that Application.ScreenUpdating = False may not be enough to keep all wb's down while running the code. It seems that Excel 2013/2016 creates new instances when I open a file, and these wb's ain't affected.

Anyone that knows of a way I can prevent this using vba?

In my code I've also started using Application.StatusBar = "Currently updating file: Group1" and so on to let me know what my code is currently doing, but when other wb's still pop up I'm losing this information as well...

 

[Norie]

Can you post your code?

 

[kit99]

Can you post your code?

It's in the link put in above, post 5 :
https://www.mrexcel.com/forum/excel...excel-2016-screen-flickering.html#post5049484

 

[Norie]

Have you got rid of all the select/activate stuff as was suggested in that thread?

 

[kit99]

Have you got rid of all the select/activate stuff as was suggested in that thread?

Sorry, haven't found the time to look at that. Thought it wasn't that critical, so I put it a bit down on my "to-do-list"...
You think this is what's causing my problems?

 

[Norie]

Well, yes.

Activating/selecting workbooks/windows etc. is usually the reason why you get 'flickering'.

 

[kit99]

Well, yes.

Activating/selecting workbooks/windows etc. is usually the reason why you get 'flickering'.

Ops...
Then I'll re-arrange my "to-do-list" at bit...
Thanks a lot for responding to my thread!