View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Simple Dumb Question: App.ScreenUpdating

You could check it:

Public Sub CheckSU()
Application.ScreenUpdating = False
test1
test2
Application.ScreenUpdating = True
End Sub

Public Sub test1()
MsgBox "test1: " & Application.ScreenUpdating
End Sub
Public Sub test2()
MsgBox "test2: " & Application.ScreenUpdating
End Sub


In article ,
"Steph" wrote:

Hi everyone. I have a question about Application.ScreenUpdating. I run a
bunch of subs from one main sub:

Sub Main()
Application.ScreenUpdating=False
sub1
sub2
sub3
Application.ScreenUpdating=True
end sub

Does the Application.ScreenUpdating carry through to all 3 subs that are
called from the Main, or should I have that in each of the 3 subs? Thank
you!!