invisible macro commands?

[Guest]

What is the command to make the steps in a macro invisible to the user? That
is, when I press the button I would like to just see the final result and not
the blinkety blinkety as each command is executed. Thx! Julie

 

[Don Guillett]

try
application.screenupdating=false
your code
application.screenupdating=true

 

[Zack Barresse]

Hi there Julie,

Add a couple of lines to your code ...


Sub YourMacroHere
Application.ScreenUpdating = false

'... your code here ...

Application.Screenupdating = true
End Sub


HTH

 

[Guest]

That does it. Thank you Don!

try
application.screenupdating=false
your code
application.screenupdating=true

 

[Don Guillett]

glad it helped