Application.Quit
I meant add it before the code that you have, not just on its own.
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"elcroco" wrote in message
ups.com...
Bob, I m not sure that your proposal answers properly to my question,
because this line of code close the workbook but not excel
Bob Phillips a écrit :
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
|