Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error
My macros disable screenupdating.
Is it possible to enable the screen updating if an error occurs in my code due to a situation in the spreadsheet prior to displaying the debug situation. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error
In simple code you could use something like
Sub test() On Error GoTo myerror With Application .ScreenUpdating = False Worksheets("DoesntExist").Select .ScreenUpdating = True End With myerror: Application.ScreenUpdating = True End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS wrote in message ... My macros disable screenupdating. Is it possible to enable the screen updating if an error occurs in my code due to a situation in the spreadsheet prior to displaying the debug situation. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
Automation Error, Unknown Error. Error value - 440 | Excel Programming | |||
Error 50290: Error writing to Worksheet while using an ActiveX Control | Excel Programming |