make macro run quietly
 

How do I make a macro run in a way that the user cannot see all the steps in
between, only the end result?


Office 2003

make macro run quietly
 

application.screenupdating=false
code
reset to true

--
Don Guillett
SalesAid Software

"K. Hulse" <K. wrote in message
...
How do I make a macro run in a way that the user cannot see all the steps
in
between, only the end result?


Office 2003

make macro run quietly
 

Whayt Don said plus be sure to have an "on error" section in the code to
reset to true - or when your code crashes excel will not be updating the
screen and you will need to close and reopen the app

"K. Hulse" wrote:

How do I make a macro run in a way that the user cannot see all the steps in
between, only the end result?


Office 2003