Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Screen Updating
Is there a way to prevent screenupdating when calling a macro from
inside another macro? In this example when running macro 1, macro 2 is called and one of the lines says screenupdating=true and would then update the screen before macro 3 runs. ( I am actually running into this because im using ActiveX boxes with cmb_change() ) the only thing i can think of is to set a bunch of variables as boolean and use if then statements before the application.screenupdating=true command. Unless there is a way to set a variable for the original caller sub? Thanks sub macro1() application.screenupdating=false Call macro2 Call macro3 ' Not shown application.screenupdating=true end sub sub macro2() application.screenupdating=false 'do some code application.screenupdating =true End sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Screen Updating | Excel Programming | |||
Screen Updating | Excel Worksheet Functions | |||
Screen Updating | Excel Programming | |||
Screen updating | Excel Programming | |||
Screen Updating | Excel Programming |