How do I keep Excel from "Blinking" during programmatic worksheet addition

[steverspr]

I have a VBA application that launches another Excel Workbook. When I programmatically add a new worksheet
to the other workbook Excel "blinks" several times. How do I keep the focus on the workbook that launches the code that adds the new worksheet to avoid this "blinking"

 

[pjmorris]

put application.screenupdating=false at the start of the macro, and change it back application.screenupdating=true at the end. It might be worth including some error handling so that if an error occurs rather than just crashing out it goes to the end of the macro and resets the status of screenupdating. I usually also put application.enableevents=false at the start of a macro and application.enableevents=true at the end - it just stops a lot of code running before you want it to!

HTH

 

[steverspr]

I implemented your suggestion and it appears to have worked. Thanks.

 

[pjmorris]

delighted to have helped. thanks for the feedback.