Thread: Screen Updating
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Screen Updating

Ps. If you close excel, reboot the pc and start again, do you have the same
trouble?

(If that setting always stays on???)

" wrote:

I'm using Excel 2003. I start out each prodedure with the following
two lines of code:

Application.EnableEvents=False
Application.ScreenUpdating=False

From the beginning of time until now, these two lines of code worked
as desired. Now, however, the value for Application.ScreenUpdating
remains True. I've trapped the code to move through each line of code.
The line of code is read, but the value remains True.

Application.EnableEvents works as expected. The value changes to
False.

Has anyone been encountering this issue?

Thanks.

Michael


--

Dave Peterson