Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to hide all the actions while a macro is running
Is there a way or a code to hide all the actions while a
macro is running? Thanks, milo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to hide all the actions while a macro is running
application.ScreenUpdating=False
-----Original Message----- Is there a way or a code to hide all the actions while a macro is running? Thanks, milo . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to hide all the actions while a macro is running
Don't forget to change that to true at the end of the
macro Sub MyMacro() application.ScreenUpdating=False 'do your thing application.ScreenUpdating=True End Sub Regards, Peo Sjoblom -----Original Message----- application.ScreenUpdating=False -----Original Message----- Is there a way or a code to hide all the actions while a macro is running? Thanks, milo . . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to hide all the actions while a macro is running
Use this line of code at the start of the macro and it stops all the actionfrom appearing on the screen. ScreenUpdating = False -----Original Message----- Is there a way or a code to hide all the actions while a macro is running? Thanks, milo . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide screen movements when a macro is running | Excel Discussion (Misc queries) | |||
how can we hide the steps of macro running | Excel Discussion (Misc queries) | |||
If I have my sheets protected will that prevent me running a macro to hide certain sells? | Excel Worksheet Functions | |||
Hide "Excel" when running VB | Excel Discussion (Misc queries) | |||
How to change macro so it performs actions on ACTIVE sheet? | Excel Discussion (Misc queries) |