View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Daniel CHEN Daniel CHEN is offline
external usenet poster
 
Posts: 16
Default How to stop the user from seeing what's going on

Try to use the following statement:

Application.DisplayAlerts = False

===== * ===== * =====
Daniel CHEN

www.Geocities.com/UDQServices
Download Free Data Processing Add-in
===== * ===== * =====

"Jeff" wrote in message
...
If I have a macro that, for example, does 10 things. How can I prevent
the
user from seeing the macro whip through the worksheet doing all 10 things?
In access there is a SetWarnings property. Is there something similar in
Excel?

Thanks in advance