View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Screenupdating in 2003

I don't think that correct. If it were this would return True:

Sub FirstSub()
SecondSub
MsgBox Application.ScreenUpdating
End Sub

Sub SecondSub()
Application.ScreenUpdating = False
End Sub


--
Jim
"LtLeary" wrote in message
m...
|I just noticed that excel 2003 sp2 will set the screenupdating property
back
| to true as soon as you leave the procedure that set screenupdating= false.
|
| Is there as switch or workaround for this ("I would really hate to have to
| check for screenupdating in every proc I have!!)
|
|
| For example
| Sub Test()
| application.screenupdating = false
| '.. other code
| ' call another sub
| ScreenTest
| debug.print application.ScreenUpdating 'will return True both here
| and in the called sub
| application.ScreenUpdating = True
| end sub
|
| Thanks
|
| LT
|
|
|