Hide Macro Process

[Brian Morrison]

Is there a way to hide all the work the macro is doing so that the end user
doesnt see the code develope.

I have a macro that produces a bunch of charts and edits them. This
currently is all shown with the screen flashing back and forth.

Can i hide this?

[TK]

Brian:

At the start of your code use:
Application.ScreenUpdating = False

at the end:
Application.ScreenUpdating = True

Good Luck
TK


"Brian Morrison" wrote:

> Is there a way to hide all the work the macro is doing so that the end user
> doesnt see the code develope.
>
> I have a macro that produces a bunch of charts and edits them. This
> currently is all shown with the screen flashing back and forth.
>
> Can i hide this?