What is the command to hide macro operations

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Martin C - 08 Feb 2008 09:13 GMT

I used to know this, but have forgotten it and cannot find it through Google
for the Excel help.

I have written a macro for a spreadsheet, but it is rather slow in running.
I once used a command that effectively hid the operations taking place by
the macro from the screen. This significantly increased the speed at which
the macro ran.

Does any kind soul know which VBA command is required to turn off the
console refresh and then later turn it back on again.

TIA
Martin

Reply to this Message

Pete_UK - 08 Feb 2008 09:20 GMT

Put this at the beginning of your code:

Application.ScreenUpdating = False

and don't forget to include this:

Application.ScreenUpdating = True

to turn it back on again.

Hope this helps.

Pete

> I used to know this, but have forgotten it and cannot find it through Google
> for the Excel help.
[quoted text clipped - 9 lines]
> TIA
> Martin

Reply to this Message

Martin C - 08 Feb 2008 09:55 GMT

Thanks for the rapid response.
I remember now and it works.
Thanks again.
Martin

Put this at the beginning of your code:

Application.ScreenUpdating = False

and don't forget to include this:

Application.ScreenUpdating = True

to turn it back on again.

Hope this helps.

Pete

On Feb 8, 9:13 am, "Martin C" <mart...@invalid.com> wrote:

> I used to know this, but have forgotten it and cannot find it through
> Google
[quoted text clipped - 11 lines]
> TIA
> Martin

Reply to this Message

Pete_UK - 08 Feb 2008 10:23 GMT

You're welcome, Martin - glad to help.

Pete

> Thanks for the rapid response.
> I remember now and it works.
[quoted text clipped - 34 lines]
>
> - Show quoted text -

Reply to this Message