Long Macro - Screen Flickers

  • Thread starter Thread starter sosteffo
  • Start date Start date
S

sosteffo

I have a macro which is quite long winded, and everytime it runs th
user has to watch the screen flickering between sheets/selecting row
etc.....looks really un-professional.

Is there a way to hide this, or show the user something else...maybe
processing / loading screen.

Any suggestions much appreciated
 
application.screenupdating=false
your code
application.screenupdating=true
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Screen Flicker 4
Screen flickers while macro is running 4
Screen flickers and text disappears/moves?? 10
Screen Flickers and slows down worksheet functions 5
Flickering of the Screen when the Macro runs. 3
After Macro runs, no cell activated - what am I missing? 2
Creating macro for slightly complicated formula 1
Screen running/ flickering (like a TV) 6

Back
Top