Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping screens from flashing using Screenupdating
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to NOT show other screens flashing by when macro runs | Excel Programming | |||
Splash screens from VBA! | Excel Programming | |||
Dual Screens | Excel Discussion (Misc queries) | |||
Two Screens??? | Excel Discussion (Misc queries) | |||
Pop Up Screens | Excel Programming |