Exit with out saving
 

How do I get excel to use the application.quit function
without wanting to save before exit

Thanks

Greg

Exit with out saving
 

ThisWorkbook.Saved = True
Application.Quit

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Greg" wrote in message
...
How do I get excel to use the application.quit function
without wanting to save before exit

Thanks

Greg

Exit with out saving
 

ActiveWorkbook.Close False ' False here means do not save changes
Application.Quit
--
- K Dales


"Greg" wrote:

How do I get excel to use the application.quit function
without wanting to save before exit

Thanks

Greg

Exit with out saving
 

Application.DisplayAlerts = False
Application.Quit

If DisplayAlerts is False, Excel will not prompt you to save any unsaved
data, nor will it actually save anything.

--
Hmm...they have the Internet on COMPUTERS now!


"Greg" wrote:

How do I get excel to use the application.quit function
without wanting to save before exit

Thanks

Greg

Exit with out saving
 

Thanks Bob works great

Greg
"Bob Phillips" wrote in message
...
ThisWorkbook.Saved = True
Application.Quit

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Greg" wrote in message
...
How do I get excel to use the application.quit function
without wanting to save before exit

Thanks

Greg