Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PLEASE PLEASE HELP Application.Screenupdating
Hi, I have been successfully using Application.Screenupdating = false before running my code and Application.Screenupdating = true after to get the macro to run faster. Suddenly Application.Screenupdating = false doesn't work anymore. After running that line of code checking the value of Application.Screenupdating gives you true! So it always keeps it true. I can change the value to flase in the immediate pane. It changes but then running any other line of code from the macro resets it to true. Please help me fix this. All my macros are now running soooo slowly. Thanks Note :The only change I remember making was setting the ignore other applications options in the general tab but I've removed that now and still it doesn't work. -- modjoe23 ------------------------------------------------------------------------ modjoe23's Profile: http://www.excelforum.com/member.php...o&userid=26376 View this thread: http://www.excelforum.com/showthread...hreadid=401555 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
PLEASE PLEASE HELP Application.Screenupdating
I've never seen this line of code not work. But I have seen this setting get
changed to true. I think I'd add a bunch of: debug.print "step #1: " & application.screenupdating to see where it gets turned off. Once you find the problem, you can add a line to turn it off. modjoe23 wrote: Hi, I have been successfully using Application.Screenupdating = false before running my code and Application.Screenupdating = true after to get the macro to run faster. Suddenly Application.Screenupdating = false doesn't work anymore. After running that line of code checking the value of Application.Screenupdating gives you true! So it always keeps it true. I can change the value to flase in the immediate pane. It changes but then running any other line of code from the macro resets it to true. Please help me fix this. All my macros are now running soooo slowly. Thanks Note :The only change I remember making was setting the ignore other applications options in the general tab but I've removed that now and still it doesn't work. -- modjoe23 ------------------------------------------------------------------------ modjoe23's Profile: http://www.excelforum.com/member.php...o&userid=26376 View this thread: http://www.excelforum.com/showthread...hreadid=401555 -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
PLEASE PLEASE HELP Application.Screenupdating
I'm not sure, but I may have panicked. I was just thinking of ho possible it is that excel would set screenupdating to true in debu mode so that people can look at the sheets during that time. I' definitely not sure of this i'm just speculating. If that's the cas then the reports are slowing down because of something else -- modjoe2 ----------------------------------------------------------------------- modjoe23's Profile: http://www.excelforum.com/member.php...fo&userid=2637 View this thread: http://www.excelforum.com/showthread.php?threadid=40155 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
PLEASE PLEASE HELP Application.Screenupdating
Does your code insert/delete rows or columns?
If yes, then having that dotted line indicating where the page breaks should go can slow down your macro. Something like: ActiveSheet.DisplayPageBreaks = False at the top of the code could speed things up. modjoe23 wrote: I'm not sure, but I may have panicked. I was just thinking of how possible it is that excel would set screenupdating to true in debug mode so that people can look at the sheets during that time. I'm definitely not sure of this i'm just speculating. If that's the case then the reports are slowing down because of something else. -- modjoe23 ------------------------------------------------------------------------ modjoe23's Profile: http://www.excelforum.com/member.php...o&userid=26376 View this thread: http://www.excelforum.com/showthread...hreadid=401555 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SendKeys and Application.ScreenUpdating | Excel Programming | |||
Using the Application.ScreenUpdating = False? | Excel Programming | |||
Question on application.screenupdating | Excel Programming | |||
Application.screenUpdating = False | Excel Programming | |||
Application.ScreenUpdating malfunction | Excel Programming |