Help Hide Looping Process

S

Steve

I have a Macro that does a lot of calculateing and copying to to other
sheets in the workbook. During the process, it is all shown on the screen
zipping along. Is there a simple way to turn the screen off or do it in
background and show the finish at the end of Macro process?

Thanks

Steve
 
D

Don Guillett

try
application.screenupdating=false
yourcode
application.screenupdating=false
 

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

Top