Do not show a macro's steps

**Andrew-Mark** · 07-15-2009, 09:48 AM

I am sure this must be on here somewhere but my search skills are not up to tracking it down.

I have written a macro, big cheers as it's my first, and it even works as I wanted it to.

Trouble is when you run it, it shows you all the steps it is making. Is there any way to stop this and purely for the end result to appear? It may well also have something to do with my PC needing more RAM to make it faster. Ever since upgrading (?) to 2007, my PC feels like it is stuck in quicksand.

**D_Rennie** · 07-15-2009, 09:57 AM

Place At the Start of you code.
Application.ScreenUpdating = False
Place At points of your code that you may want to show.
Application.ScreenUpdating = True

**romperstomper** · 07-15-2009, 09:57 AM

Use:

Please Login or Register  to view this content.

I would also guess that your code probably selects everything it manipulates - that is almost never necessary. For example, rather than:

Please Login or Register  to view this content.

you can just use:

Please Login or Register  to view this content.

**puhoo** · 07-15-2009, 09:59 AM

You have just to insert the following code in front of your syntaxes.
Application.ScreenUpdating = False

Originally Posted by Andrew-Mark

I am sure this must be on here somewhere but my search skills are not up to tracking it down.

I have written a macro, big cheers as it's my first, and it even works as I wanted it to.

Trouble is when you run it, it shows you all the steps it is making. Is there any way to stop this and purely for the end result to appear? It may well also have something to do with my PC needing more RAM to make it faster. Ever since upgrading (?) to 2007, my PC feels like it is stuck in quicksand.

**mewingkitty** · 07-15-2009, 10:12 AM

Can put in :

Application.ScreenUpdating = False

Then just make it true again at the end.
Also may want to disable automatic calculations for the duration of the macro if you have calculations which are updating as you go and slowing it down