| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn screen update off; then back on during macro
I'm new to Excel VBA and struggling with syntax.
I have a macro tied to a form command button. I'd like to: 1. Turn the Excel screen update(s) off; 2. Run the code on the button; 3. Turn the Excell screen updates back on. Is there a method/class/whatever to do this? The macro adds data to a couple of worksheets; I'd like the macro to run without showing the user what's going on. Thanks! in advance. --Dan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Turn screen update off; then back on during macro
Hi Dan
Put this at the beginning of your macro: Application.ScreenUpdating = False This one before End Sub Application.ScreenUpdating = True HTH John "Dan" wrote in message ... I'm new to Excel VBA and struggling with syntax. I have a macro tied to a form command button. I'd like to: 1. Turn the Excel screen update(s) off; 2. Run the code on the button; 3. Turn the Excell screen updates back on. Is there a method/class/whatever to do this? The macro adds data to a couple of worksheets; I'd like the macro to run without showing the user what's going on. Thanks! in advance. --Dan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Turn screen update off; then back on during macro
:) Thanks!
"John" wrote: Hi Dan Put this at the beginning of your macro: Application.ScreenUpdating = False This one before End Sub Application.ScreenUpdating = True HTH John "Dan" wrote in message ... I'm new to Excel VBA and struggling with syntax. I have a macro tied to a form command button. I'd like to: 1. Turn the Excel screen update(s) off; 2. Run the code on the button; 3. Turn the Excell screen updates back on. Is there a method/class/whatever to do this? The macro adds data to a couple of worksheets; I'd like the macro to run without showing the user what's going on. Thanks! in advance. --Dan . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Turn screen update off; then back on during macro
You're welcome Dan
I'm new to VBA myself, but knew your answer. Regards John "Dan" wrote in message ... :) Thanks! "John" wrote: Hi Dan Put this at the beginning of your macro: Application.ScreenUpdating = False This one before End Sub Application.ScreenUpdating = True HTH John "Dan" wrote in message ... I'm new to Excel VBA and struggling with syntax. I have a macro tied to a form command button. I'd like to: 1. Turn the Excel screen update(s) off; 2. Run the code on the button; 3. Turn the Excell screen updates back on. Is there a method/class/whatever to do this? The macro adds data to a couple of worksheets; I'd like the macro to run without showing the user what's going on. Thanks! in advance. --Dan . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I turn the screen off during macro execution | Excel Worksheet Functions | |||
| How do I turn 'update links' back on when turned off? | Excel Worksheet Functions | |||
| Turn off Screen Saver by Macro | Excel Programming | |||
| back-end update excel file macro | Excel Programming | |||
Hybrid Mode
