Hidding the running of a Macro.

[Zac]

Is there a way to hide the running of a macro
(actually showing the macro in action) from the user?

IE: They push the Button, they wait, the results appear. Rather than they Push the Button, and the screen goes crazy showing what the macro is doing.

I saw this once before but I have no idea where to look in the Archive files.

Thanks,
Zac

 

[Todd_M]

Application.ScreenUpdating = False

your code goes here.....


Application.ScreenUpdating = True


Hope this helps-Todd

 

[Zac]

Thanks Todd.