| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Macro Actions
Is there a way I can "hide" the actions when a macro is being run instead of
watching excel bounce around until it has run it's course? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide Macro Actions
application.screenupdating = false
at the start of the macro, and application.screenupdating = true at the end of the macro |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide Macro Actions
It worked. Thank you!
"Keith74" wrote: application.screenupdating = false at the start of the macro, and application.screenupdating = true at the end of the macro |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide Macro Actions
Possibly:-
sub yoursub() applications.screenupdating = false do your stuff application.screenupdating = True end Sub Mike "FrankTimJr" wrote: Is there a way I can "hide" the actions when a macro is being run instead of watching excel bounce around until it has run it's course? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide actions while macro executes | Excel Programming | |||
| 2007: Macro recording not working for some actions | Excel Programming | |||
| How to change macro so it performs actions on ACTIVE sheet? | Excel Discussion (Misc queries) | |||
| Subtotal Macro weird actions | Excel Programming | |||
| How to hide all the actions while a macro is running | Excel Programming | |||
Hybrid Mode
