Excel 2013 user form is flickering when it wasn't in Excel 2010

Good evening friends,

I prepared a macro using VBA for Excel 2010 that used a user form (and screenupdating=false) to display a progress bar. It worked fine, but my work has just updated to Excel 2013 and although the macro works, the problem is that the screen flickers.

I have had a look, and the problem is that I use the command:

Please Login or Register  to view this content.

This appears not to be an issue in Excel 2010 because it doesn't use (by default) multiple instances of the application.

My macro doesn't use activate or select commands, because I was being really careful, but when I add a workbook the new workbook is activated; this causes my screen to flicker.

Is there a way to add a workbook without activating that new workbook (ie: without losing focus of active workbook)?

Any help is appreciated.

In my code, I turn the screen updating off at the very start of the project, which looks like below (minus some details). Due thanks to Excel 2003 VBA for Dummies for the main structure.

I could turn off the screen updating, but it would still cause the page to flicker. I am striving too much?

Just to confirm, Excel 2013 is being a pain because it insists you open each new workbook in a new instance of the application. If I didn't have to do that, and have all books in one excel instance then I'd be happy.

Please Login or Register  to view this content.