View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default Application.Quit

Maybe try

Activeworkbook.Close Savechanges:=False

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"elcroco" wrote in message
ups.com...
Hi,

I forgot in my first message the Application.DisplayAlerts = False I
have set in my procedure
It doesn't work because the "Save" dialog box is not an alert

G


Roger Govier a écrit :

Hi

Application.DisplayAlerts = False

--
Regards

Roger Govier


"elcroco" wrote in message
ups.com...
I would like to use this function in one of my application.So I wrote
the following code:

Sub sTestAppQuite()

Application.Display
Application.Quit

End Sub

When I m testing it, the "Save" dialog box opens, asking me whether or
not I want to save the workbook. As I would like to avoid this
behaviour, what I hhave to do ???

Thanks

G