Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.ScreenUpdating
Hello,
I am using Application.ScreenUpdating = False at the start of my code. However, if the code stops do to an error or I am debugging and don't let the code finish, I am unable to access Excel at that point because screen updating remains false. How do I get ScreenUpdating to go back to updating so I can get back into Excel and access the different workbooks? Thanks, Scott |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.ScreenUpdating
I thought screenupdating always reset back to true when code ended (either
nornally or after an error) If you're stuck with it turned off then you might be able to use the immediate window to type Application.Screenupdating=True then hit enter Tim "Scott" wrote in message ... Hello, I am using Application.ScreenUpdating = False at the start of my code. However, if the code stops do to an error or I am debugging and don't let the code finish, I am unable to access Excel at that point because screen updating remains false. How do I get ScreenUpdating to go back to updating so I can get back into Excel and access the different workbooks? Thanks, Scott |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.ScreenUpdating
Scott wrote:
Hello, I am using Application.ScreenUpdating = False at the start of my code. However, if the code stops do to an error or I am debugging and don't let the code finish, I am unable to access Excel at that point because screen updating remains false. How do I get ScreenUpdating to go back to updating so I can get back into Excel and access the different workbooks? Thanks, Scott In the VBE, press Ctrl+G, then type application.screenupdating = true |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.ScreenUpdating
Include error handling to take care of the problem; something like this...
Sub Missive() ..... ..... On Error GoTo SomethingWentWrong Application.ScreenUpdating = False ..... ..... <<your code goes here ..... SomethingWentWrong: Application.ScreenUpdating = True End Sub -- Rick (MVP - Excel) "Scott" wrote in message ... Hello, I am using Application.ScreenUpdating = False at the start of my code. However, if the code stops do to an error or I am debugging and don't let the code finish, I am unable to access Excel at that point because screen updating remains false. How do I get ScreenUpdating to go back to updating so I can get back into Excel and access the different workbooks? Thanks, Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application.ScreenUpdating broken? | Excel Programming | |||
Application.ScreenUpdating | Excel Programming | |||
Application.ScreenUpdating is ineffective | Excel Programming | |||
PLEASE PLEASE HELP Application.Screenupdating | Excel Programming | |||
problem with Application.ScreenUpdating | Excel Programming |