A way to not refresh data on screen?

K

Kenji

When I run the macro, the Excel sheet does a bunch of activities.

Is there a way to disable refreshing the screen.. so the user doesn't have
to see all the data being written in as it's done?

Kenji
 
P

Peo Sjoblom

Sub Macro()
Application.ScreenUpdating = False
'your code
Application.ScreenUpdating = True
End Sub
 
A

A.W.J. Ales

Kenji,

Sub test()
Application.Screenupdating = False

your macro contents

Application.Screenupdating = True
End Sub

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
K

Kenji

Thanks AWJ Ales and lexiinlace, it worked beautifully and made things 10x
faster!

Kenji
 
Top