Re: I can not stop save warning message when I click Close (x) botton or Alt+F4

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

What did you do exactly with my suggestion? The code you have below with definitely not work. Application.DisplayAlerts just stops the application showing them AND it takes the default answer. In the case of save yes/no the default is yes.

If you can explain what you did with my suggestion, maybe we can help develop it further?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@xxxxxxxxxxxxxxxx
www.nickhodge.co.uk


"botcan" <botcan@xxxxxxxxx> wrote in message news:1174787719.512687.197440@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Thanks a lot for your reply Nick,
No way, it doesn' work either.
I forgot to say but I had tried that too:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Application.DisplayAlerts = False
End Sub

:( Any other idea?


.

Relevant Pages

  • Re: Unwished characters printing
    ... Any other suggestion would be greatly ... Bill M. ... >Doug Robbins - Word MVP ... >> the bloody line keeps showing in every page. ...
    (microsoft.public.word.printingfonts)
  • Re: Problem: Phantom Numbers Printing on Hard Copy in Word 2003 Docume
    ... You say "two-column brochure". ... This would seem less likely, however, since they're not showing up ... > This post is a suggestion for Microsoft, ... To vote for this suggestion, ...
    (microsoft.public.word.application.errors)
  • Re: postings not being made
    ... None of mine were showing up and when they did, ... > The day started out with not showing any of todays postings until about ... > This post is a suggestion for Microsoft, ... To vote for this suggestion, ...
    (microsoft.public.excel.misc)
  • Re: character matching
    ... I support Steve's suggestion. ... Yours has the advantage of showing ... I guess this is useful for learning ...
    (comp.lang.ada)
  • Re: How do I
    ... > special characters whatsoever involved in this column, ... >> Showing a couple examples will insure a more specific suggestion. ... Dave Peterson ...
    (microsoft.public.excel.misc)