ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Quit Application Without Saving (https://www.excelbanter.com/excel-programming/307592-re-quit-application-without-saving.html)

Frank Kabel

Quit Application Without Saving
 
Hi
use
activeworkbook.saved=true
application.quit

--
Regards
Frank Kabel
Frankfurt, Germany

"Ed the Redhead" schrieb im
Newsbeitrag ...
I have a worksheet that is a Read-Only document. About 20 people

will be
getting in, punching in their numbers, and getting an answer. I

currently
have a button that says "Quit Excel" and have the code as

Application.Quit

However, whenever I hit the button, it asks if I want to save or not.

Is
there anyway to close the document & programmatically tell it not to

save?

Thanks.




All times are GMT +1. The time now is 12:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com