LT
It seems to work fine on my system
cheers
Simon
"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