ScreenUpdating
 

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

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

ScreenUpdating
 

It's a VBA Program module within an Excel File

Paul

"John" wrote:

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