LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Closing an Unsaved (but Changed) Workbook

How do I close a worksheet that I've changed (at the same
time that I close Excel), but don't want the changes to be
permanent? I tried using the following code:

ActiveWorkbook.Saved = True
Application.Quit

However, it doesn't work; it still asks me whether I want
to save the changes.

 
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
Shared Workbook User had unsaved information disappear Aeryn635 Excel Worksheet Functions 1 January 15th 10 05:31 AM
Closing a workbook N1KO Excel Discussion (Misc queries) 0 February 12th 09 03:51 PM
How to recover unsaved workbook? P8ja Excel Discussion (Misc queries) 1 November 28th 05 12:44 PM
Dialog box when closing an unsaved spreadsheet Kathy4080 Excel Discussion (Misc queries) 1 January 4th 05 10:28 PM
closing workbook Sam Dickins Excel Programming 1 November 27th 03 03:43 PM


All times are GMT +1. The time now is 01:05 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"