Screenupdating is automatically turned back on at the end of a
sub
Very close, but not quite right. ScreenUpdating is automatically
turned by on when control is returned to Excel. Thus if procedure
A calls procedure B, which turns off ScreenUpdating,
ScreenUpdating is False even when B ends. It doesn't turn back on
until A ends.
Your statement is correct if you're talking about only a single
proc, which doesn't call another proc.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
wrote in message
oups.com...
Hi
Screenupdating is automatically turned back on at the end of a
sub
so...
regards
Paul