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

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" <[email protected]> wrote in message
news:[email protected]...
>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

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" <[email protected]> wrote in message
> news:[email protected]...
> >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
>
>
>