View Single Post
  #3   Report Post  
Zack Barresse
 
Posts: n/a
Default invisible macro commands?

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

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)



"Julieeeee" wrote in message
...
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