Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thank you both very much. The errors occure when I am trying
"Application.quit" so I really want to ignore the problem, if I can't determine what it is. The work has been accomplished at this time. Thanks again. "NickHK" wrote: ..DisplayAlerts means just that; whether to display those <helpful message from Excel. This is completely different from the error messages that you seem to see, which are raised because of problems with your code. It is generally not a good idea to use Resume Next to ignore errors, unless you know/expect what is happening and you are dealing with it. Sounds like you should fix your code. ..ScreenUpdating is always True in Break/debug mode. NickHK "OlieH" wrote in message ... Yes. What I have done is to add On Error Resume Next this does allow the program to close without display. Since I am trying to quit the program, I dont care if I get errors at this point. I am still perplexed why I can't set these to "False" however. "Tom Ogilvy" wrote: Stepping through code will likely have a different effect than running your macro normally. Do you have this problem when you run the code normally? -- Regards, Tom Ogilvy "OlieH" wrote: mI have at the end of my macro the following: Application.DisplayAlerts = False Application.ScreenUpdating = False Application.quit When I step through the first two statements they both stay "True" How have I blocked by ability to reset this parameter? The results is when I run the Application.Quit, the Macro window open and then closes. All help is greatly appreciated. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.DisplayAlerts | Excel Programming | |||
Application.Displayalerts = value (is not working for me) | Excel Programming | |||
Application.DisplayAlerts in IE | Excel Programming | |||
Application::DisplayAlerts not working | Excel Programming | |||
application.displayalerts | Excel Programming |