Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
about screenupdating | Excel Discussion (Misc queries) | |||
App.screenupdating | Excel Programming | |||
When to use screenupdating? | Excel Programming | |||
Screenupdating | Excel Programming | |||
.ScreenUpdating Problem? | Excel Programming |