View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Nik[_3_] Nik[_3_] is offline
external usenet poster
 
Posts: 12
Default Application.Quit

elcroco wrote:
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 ???

Areyou sure that the user won't have another file open and lose work in
that?

You could set thisworkbook.saved = true, which will tell Excel that
there are no chanegs to save. If there is only one workbook open, Excel
will quit; if there is another workbook the user will be prompted to
save changes if there are any.

Nik