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

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

--
Don Guillett
SalesAid Software

"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

That does it. Thank you Don!

"Don Guillett" wrote:

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

--
Don Guillett
SalesAid Software

"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

glad it helped

--
Don Guillett
SalesAid Software

"Julieeeee" wrote in message
...
That does it. Thank you Don!

"Don Guillett" wrote:

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

--
Don Guillett
SalesAid Software

"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

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