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
|
|
|
|