Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
unable to control screenupdating
I have some very extensive VBA Code running in Excel. I am having trouble
controling the screen updating. It seems that anytime I open a new workbook via VBA the screenupdating resets to True also Running in debug I can see that sometimes the command Application.screenupdating=false seems not to have any effect at all. Are there any hints/tips anyone can offer. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help with ScreenUpdating..... This is driving me nuts
I am continuing to have this problem.....
Further testing has revealed really odd behavior.... Setting a break just prior to the command "Application.ScreenUpdating=False" Set thru the command and ScreenUpdating is still True Go to the Immediate window and enter the command manually and the command has the desired effect... ScreenUpdating=False What's Up... This is driving me NUTSSSSSS "Susan Lammi" wrote in message ... I have some very extensive VBA Code running in Excel. I am having trouble controling the screen updating. It seems that anytime I open a new workbook via VBA the screenupdating resets to True also Running in debug I can see that sometimes the command Application.screenupdating=false seems not to have any effect at all. Are there any hints/tips anyone can offer. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help with ScreenUpdating..... This is driving me nuts
Hi Susan:
Please post your code. Once a macro finishes running, ScreenUpdating will automatically be reset to True. Regards, Vasant. "Susan Lammi" wrote in message ... I am continuing to have this problem..... Further testing has revealed really odd behavior.... Setting a break just prior to the command "Application.ScreenUpdating=False" Set thru the command and ScreenUpdating is still True Go to the Immediate window and enter the command manually and the command has the desired effect... ScreenUpdating=False What's Up... This is driving me NUTSSSSSS "Susan Lammi" wrote in message ... I have some very extensive VBA Code running in Excel. I am having trouble controling the screen updating. It seems that anytime I open a new workbook via VBA the screenupdating resets to True also Running in debug I can see that sometimes the command Application.screenupdating=false seems not to have any effect at all. Are there any hints/tips anyone can offer. Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help with ScreenUpdating..... This is driving me nuts
First, when you are activating another workbook that one has now become the
active workbook therefore ScreenUpdating will be set back to true. If you are opening the same workbook each time then just set screenupdating to false in that workbooks open event. "Susan Lammi" wrote in message ... I am continuing to have this problem..... Further testing has revealed really odd behavior.... Setting a break just prior to the command "Application.ScreenUpdating=False" Set thru the command and ScreenUpdating is still True Go to the Immediate window and enter the command manually and the command has the desired effect... ScreenUpdating=False What's Up... This is driving me NUTSSSSSS "Susan Lammi" wrote in message ... I have some very extensive VBA Code running in Excel. I am having trouble controling the screen updating. It seems that anytime I open a new workbook via VBA the screenupdating resets to True also Running in debug I can see that sometimes the command Application.screenupdating=false seems not to have any effect at all. Are there any hints/tips anyone can offer. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
about screenupdating | Excel Discussion (Misc queries) | |||
Screenupdating Problems | Excel Discussion (Misc queries) | |||
What does ScreenUpdating = False do? | Excel Worksheet Functions | |||
Unable to add references to Calendar control and outlook object | Setting up and Configuration of Excel | |||
Application.ScreenUpdating = False | Excel Programming |