Thread: ScreenUpdating
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John[_88_] John[_88_] is offline
external usenet poster
 
Posts: 205
Default ScreenUpdating

Hi Paul,

When you say you developed a 'program', are you talking about a VBA module
within an Excel file or a separate VB/C++ app that accesses Excels?

Best regards

John

"Paul" wrote in message
...
I have developed a program that switches between a number of sheets. To
prevent the screen from flashing every time this happens, I have included:
"Application.ScreenUpdating = False" at the start of my program. However,
it
does not appear to be working. I set a break point just after this
statement, and when I mouse over the "ScreenUpdating" variable, it says
that
it is still set to "True". Why isn't this working?

Paul