MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Hiding visible macro movement until finished


Posted by Peter Bellinger on December 11, 2001 8:26 AM

Hi,

Is it possible to disable visible output until a macro completes. I have a macro that jumps up and down a worksheet copying and calculating cells. I would prefer it if it just showed the end result.

Thanks

Pete


Posted by Barrie Davidson on December 11, 2001 8:28 AM

Use
Application.ScreenUpdating = False

before your code and make sure you put

Application.ScreenUpdating = True

at the end of your code.

BarrieBarrie Davidson

Posted by Peter Bellinger on December 11, 2001 8:38 AM

Wow - That what I call a fast response

Thanks