LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 39
Default Application.DisplayAlerts

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Application.DisplayAlerts TK Excel Programming 4 April 7th 05 08:41 PM
Application.Displayalerts = value (is not working for me) [email protected] Excel Programming 3 December 18th 04 02:00 AM
Application.DisplayAlerts in IE scoobydeux Excel Programming 1 April 19th 04 01:28 AM
Application::DisplayAlerts not working Howard Dierking Excel Programming 2 February 11th 04 12:04 PM
application.displayalerts Erin[_5_] Excel Programming 1 December 4th 03 03:49 PM


All times are GMT +1. The time now is 11:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"