| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze screen during computations
I have a macro which does data import and does computations on varios
tabs of my spreadsheet. I cannot recall the command which prevent the screen from flashing to various tabs as the macro progress. What is the command to keep the screen at the tab at which it starts and not jump around? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Freeze screen during computations
Application.ScreenUpdating = False
"fmistry" wrote: I have a macro which does data import and does computations on varios tabs of my spreadsheet. I cannot recall the command which prevent the screen from flashing to various tabs as the macro progress. What is the command to keep the screen at the tab at which it starts and not jump around? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 freeze panes won't freeze top row only | Excel Discussion (Misc queries) | |||
| print box opens in right screen of dual screen setup why | Excel Discussion (Misc queries) | |||
| What is the difference between split screen and freeze? | Excel Discussion (Misc queries) | |||
| Need to convert point on screen to various screen resolutions | Excel Discussion (Misc queries) | |||
| Computations involving text cells are not working?? | Excel Worksheet Functions | |||
Linear Mode
