In VBA in excel, there is a simple line that will turn off screen updating. My program opens many template parts to create new ones and promptly closes them causing the screen to go through a crazy routine of flashes....Adding these two lines on the outskirts of you code cause no screen flashing, and the application seems to freeze while the program is running. I'm starting to worry about the transe-like state I go into every time I run it......Good Morning Thanks for the quick response Re your comments Sensitivity issues precluded me attaching the relevant workbook and a mock up would not necessarilly be reflective of the complexity.
Slicer Caches("Slicer_Monat") Set sc8 = This Workbook.
Slicer Caches("Slicer_Monat1") Set sc9 = This Workbook.
Every time I select a value in the listbox, the screen "flickers" to the hidden worksheet.
I want to be able to do the whole process without that "flickering".
Slicer Caches("Slicer_Quarter") Set sc6 = This Workbook. Clear Manual Filter On Error Resume Next For Each si1 In sc1.