ScreenUpdating

[Guest]

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

 

[John]

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

 

[Guest]

It's a VBA Program module within an Excel File

Paul