Hide Macro Actions

[Guest]

Is there a way I can "hide" the actions when a macro is being run instead of
watching excel bounce around until it has run it's course?

 

[Guest]

Possibly:-

sub yoursub()
applications.screenupdating = false

do your stuff

application.screenupdating = True
end Sub


Mike

 

[Keith74]

application.screenupdating = false

at the start of the macro, and

application.screenupdating = true

at the end of the macro

 

[Guest]

It worked. Thank you!