| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Block display during Macro
Hello,
I execute a macro that go across the sheet and insert and copy a lot of rows and formats I would like the user doesn´t see the process, only the results. Is possible 'lock' visual effects during the macro execution. Thanks.- |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Block display during Macro
Application.ScreenUpdating = False
'your code Application.ScreenUpdating = True -- __________________________________ HTH Bob "Juan García" wrote in message ... Hello, I execute a macro that go across the sheet and insert and copy a lot of rows and formats I would like the user doesn´t see the process, only the results. Is possible 'lock' visual effects during the macro execution. Thanks.- |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Block display during Macro
Thanks...
"Bob Phillips" escribió en el mensaje ... Application.ScreenUpdating = False 'your code Application.ScreenUpdating = True -- __________________________________ HTH Bob "Juan García" wrote in message ... Hello, I execute a macro that go across the sheet and insert and copy a lot of rows and formats I would like the user doesn´t see the process, only the results. Is possible 'lock' visual effects during the macro execution. Thanks.- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to highlight changes in my data from one block of cells toanother block of cells? | Excel Programming | |||
| Set range to block of cells in Macro | Excel Discussion (Misc queries) | |||
| How to block all macro when a particular file is open | Excel Programming | |||
| Macro to test characters with block of cells and change font | Excel Programming | |||
| Cell Block and Furmula Bar display | Excel Discussion (Misc queries) | |||
Linear Mode
