I have an application that uses forms for input and worksheets as data tables. The code looks something like this:
Application.Screenupdating = False
Sheets("Sheet1").visible = True
Sheets("Sheet1").activate
' update some rows within sheet1...
..
..
Sheets("Sheet1").visible = False
Application.Screenupdating = True
There are a bunch of code similar to this with muliple sheets being selected for update throughout the application within the Application.Screenupdating. The problem is that I see the sheets flickering in the background while the form is running. I thought the Application.Screenupdating = false suppress this. Any advice?
Application.Screenupdating = False
Sheets("Sheet1").visible = True
Sheets("Sheet1").activate
' update some rows within sheet1...
..
..
Sheets("Sheet1").visible = False
Application.Screenupdating = True
There are a bunch of code similar to this with muliple sheets being selected for update throughout the application within the Application.Screenupdating. The problem is that I see the sheets flickering in the background while the form is running. I thought the Application.Screenupdating = false suppress this. Any advice?