Processing
 

Excel 2013 and 2016 flicker when ScreenUpdating = False and creating a new hidden workbook

15/09/2016 18:27#1

tjsmith

Member

Joined at: 4 months ago

Post: 1

Thank: 0

Thanked: 0

If you run the code below in Excel 2013 or Excel 2016 then it will cause Excel to flicker.

Does anyone have any suggestions on how to stop the flickering?

Sub FlickerTestMain()     Application.ScreenUpdating = False     Application.EnableEvents = False     Application.DisplayAlerts = False      FlickerTestHelper      Application.ScreenUpdating = True     Application.EnableEvents = True     Application.DisplayAlerts = True End Sub  Sub FlickerTestHelper()     Dim currentWorkbook As Workbook, newWorkbook As Workbook     Set currentWorkbook = Application.ActiveWorkbook     Set newWorkbook = Application.Workbooks.Add(xlWBATWorksheet)     newWorkbook.Windows(1).Visible = False     currentWorkbook.Activate     newWorkbook.Worksheets(1).Range("a1:Z10000").Value2 = "test"     newWorkbook.Close False End Sub 
Similar articles

Excel More conditions in one formula?

4 months ago - Reply: 2 - Views: 171

Get Workbook reference from Open File dialog

4 months ago - Reply: 2 - Views: 128

Add Calculated Field To Pivot Table

4 months ago - Reply: 0 - Views: 5

Nested IF Functions in Excel not working

4 months ago - Reply: 3 - Views: 163

Formulating Date in Excel 2013

5 months ago - Reply: 2 - Views: 88

VB6 extracts in Excel 2013

5 months ago - Reply: 2 - Views: 153

Excel 2013 : Pull Matching Data from Column

5 months ago - Reply: 1 - Views: 19

excel search and copy in/from another file

5 months ago - Reply: 0 - Views: 1

Buggy PivotTable.ColumnRange

5 months ago - Reply: 0 - Views: 4

Excel static conditional formatting area

5 months ago - Reply: 0 - Views: 8

vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re