View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Application.ScreenUpdating is ineffective

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