Stopping screens from flashing using Screenupdating
Hi,
I have used the false, code, true combination in all subs. The screens
still keep flashing. Any other ideas?
Thanks,
Raj
On Jun 3, 11:15*am, NateBuckley
wrote:
Public Sub main()
* * Application.ScreenUpdating = False
* * 'Main Code goes between the two states.
* * Application.ScreenUpdating = True
End Sub
That's how I generally Use it and it works.
"Raj" wrote:
Hi,
In the Worksheet_deactivate event of Master worksheet, I activate the
Input worksheet. The Input worksheet_activate event then runs a macro
to form a pivot table in Table worksheet and use the values in the
Table worksheet to write a report in the Report worksheet.
When I deactivate Master worksheet all this happens, but there is
rapid flashing of various worksheets before the final output sheet
appears. I have tried using Screenupdating = false at various points.
How exactly do I use this Application property to avoid screens
flashing? Is there any other way to do this?
Thanks in advance for the help.
Regards,
Raj- Hide quoted text -
- Show quoted text -
|