Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to close excel application other than application.quit mary Excel Programming 1 September 14th 04 03:43 PM
The old application.quit problem Don Guillett[_4_] Excel Programming 1 June 20th 04 03:08 PM
Application.quit yuiriy Excel Programming 4 June 10th 04 08:36 AM
application.quit will not shut off application john Excel Programming 0 January 9th 04 11:29 PM
Quit Application Robert Black Excel Programming 1 July 31st 03 04:15 PM


All times are GMT +1. The time now is 02:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"