Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to stop the user from seeing what's going on
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to stop the user from seeing what's going on
Also try Application.ScreenUpdating = False
That will stop them from seeing excel activate the worksheets. *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to stop the user from seeing what's going on
"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? I use: Application.ScreenUpdating = False at the start of each "action" sub then the opposite at the end. This freezes the image on the screen until it's finished running. Excel will show msgbox's whilst screenupdating is disabled but if the user moves the message box it makes the screen look wierd. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to stop the user from seeing what's going on
Thanks. I was getting an error message with that when I didn't include the
equal sign (don't have to in Access). Works fine now. "Darrin Henshaw" wrote: Also try Application.ScreenUpdating = False That will stop them from seeing excel activate the worksheets. *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I stop the end user License agreement from popping up | Excel Worksheet Functions | |||
Can you stop user name from appearing in comment? | Setting up and Configuration of Excel | |||
Macro stop if file in use by other user? | Excel Discussion (Misc queries) | |||
How do I stop the User names in comments from appearing? | Excel Discussion (Misc queries) | |||
How do i stop the End user License Agreement from Popping Up upon. | Excel Discussion (Misc queries) |