Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Screen flash while running macros
I have a macro set up to run when you enter a worksheet. This macro
serarches out blank cells & hides the row that they are in. Is there a way to prevent the screen from flashing while this macro is running? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Screen flash while running macros
Sub demo()
Application.ScreenUpdating = False ' your code goes here Application.ScreenUpdating = True End Sub -- Gary''s Student - gsnu200759 "Jay" wrote: I have a macro set up to run when you enter a worksheet. This macro serarches out blank cells & hides the row that they are in. Is there a way to prevent the screen from flashing while this macro is running? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Screen flash while running macros
At the beginning of your macro, insert this line:
Application.ScreenUpdating = False At the end of your macro (or in your error_exit, if you have error handling), insert this line: Application.ScreenUpdating = True If your macro ever crashes and the screen stops updating, use this line and paste it in the Immediate window (Ctrl+G to open window, Ctrl +V to paste, then press Enter to execute): Application.ScreenUpdating = True On Dec 3, 4:12 pm, Jay wrote: I have a macro set up to run when you enter a worksheet. This macro serarches out blank cells & hides the row that they are in. Is there a way to prevent the screen from flashing while this macro is running? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Macros | Links and Linking in Excel | |||
Running Macros | Excel Discussion (Misc queries) | |||
Running Macros | Excel Worksheet Functions | |||
running macros from IF | Excel Worksheet Functions | |||
running macros | Excel Discussion (Misc queries) |