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