Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, I have successfully used the "Application.ScreenUpdating = False"
statement in the past, but for some reason it is not working for me now. Here is my VBA: Sub calculateEvent() Dim row As Integer Dim isBlank As Boolean 'Turn off calculations and screen updating Application.ScreenUpdating = False Workbooks("Master.xls").Sheets("CurrentSD").Enable Calculation = False 'Go through row by row, determine if any SDs are greater than 2 row = 2 isBlank = False 'If SD greater than 2 determine status and take appropriate action Do While isBlank = False If Workbooks("Master.xls").Sheets("CurrentSD").Range( "D" & row).Value = 2 Then If Workbooks("Master.xls").Sheets("CurrentSD").Range( "E" & row).Value = "NULL" Then 'CALL openProposal() End If If Workbooks("Master.xls").Sheets("CurrentSD").Range( "E" & row).Value = "OPEN" Then 'Call reopenProposal() End If If Workbooks("Master.xls").Sheets("CurrentSD").Range( "E" & row).Value = "CLOSING" Then 'Call cancelCloseProposal() End If End If 'increment row row = row + 1 If Workbooks("Master.xls").Sheets("CurrentSD").Range( "A" & row).Value = "" Then isBlank = True Range("A23").Value = "test" Loop 'Turn on Calculations and screen updating Workbooks("Master.xls").Sheets("CurrentSD").Enable Calculation = True Application.ScreenUpdating = True End Sub If I step through the code and mouseover Application.ScreenUpdating directly after the "Application.ScreenUpdating = False" statement it still says "Application.ScreenUpdating = TRUE"?!?!?! Is there some setting I don't know about that is not letting me turn off screen updating. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date matter | New Users to Excel | |||
Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
Screenupdating is always true | Excel Programming | |||
True Or False, no matter what... it still displays the false statement | Excel Programming | |||
ScreenUpdating automatically resets to True | Excel Programming |