Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |