Hide Macro Actions
 

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?

Hide Macro Actions
 

Possibly:-

sub yoursub()
applications.screenupdating = false

do your stuff

application.screenupdating = True
end Sub


Mike
"FrankTimJr" wrote:

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?

Hide Macro Actions
 

application.screenupdating = false

at the start of the macro, and

application.screenupdating = true

at the end of the macro

Hide Macro Actions
 

It worked. Thank you!

"Keith74" wrote:

application.screenupdating = false

at the start of the macro, and

application.screenupdating = true

at the end of the macro