Forum Discussion

David Griggs's avatar
David Griggs
Copper Contributor
Aug 15, 2018

Application.ScreenUpdating

I have seen the other posts on this topic, where the property does not function in Excel 2016, but there still does not appear to be a remedy for this problem.   I, like probably thousands of vba w...
Macros and VBA
Elle100's avatar
Elle100
Copper Contributor
Jun 23, 2019
Sorry, I realized I had the workbook (to be updated) minimized and that's why it worked! Try this, although there might be better code to minimize a particular workbook window, the following was OK for me. Application.ScreenUpdating = False Dim wbName As Window Set wbName = Windows("your workbook name") wbName.Visible = False ' other code here Application.ScreenUpdating = True wbName.Visible = True
Elle100's avatar
Elle100
Copper Contributor
Jun 23, 2019

Elle100 

That didn't format very well, let me try again.  Also, I found a neater way to minimize the workbook being updated.

Application.ScreenUpdating = False
Dim wbName As Window
Set wbName = Windows("name of workbook being updated")
wbName.WindowState = xlMinimized

' other code in here

Application.ScreenUpdating = True
wbName.WindowState = xlMaximized

 

Resources