is there a way to disable screen updates?

I

ILiya

I'd like to disable screen updates for a time like before and after the
rutine which may produce undesired visual effects to the user like
enumerating and activating worksheets in loops and then returning to the
sheet that was originally activated.

Thanks
 
J

Jens Lenge

Application.ScreenUpdating = False

....

Application.ScreenUpdating = True

Hope this helps,
Jens
 

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

Want to have macro execute automatically when doc created 3
A couple questions BEFORE using Office 365 0
Move Chart with Text 0
ECHO OFF applying to MULTIPLE Macros or MODULES! 1
Synchronization problems while moving folders to new email 1
Disable Welcome Screen 0
Enabling Macros message when NO macros in workbook 3
Turn screen update off; then back on during macro 3

Top