Thread: screenupdating = false not working in Workbook_open sub
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default screenupdating = false not working in Workbook_open sub
I've never seen this line ignored.

But I have seen calls to built in routines turn it back on. (No, I don't
remember what they were. Sorry.)

Maybe you can post your troublesome code (and the version of excel) that causes
the problem.

TommySzalapski wrote:

Application.ScreenUpdating = False

This code works well except in the Private Sub Workbook_Open() macro
where it seems to be comepletely ignored. Why?

thanks,
Tommy

--
TommySzalapski
------------------------------------------------------------------------
TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561
View this thread: http://www.excelforum.com/showthread...hreadid=391960

--

Dave Peterson
Reply With QuoteReply With Quote