| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing an Unsaved (but Changed) Workbook
Thanks Bill!
-----Original Message----- Switch the order Application.Quit ActiveWorkbook.Close SaveChanges:=False Quits, but does not bring up save changes dialog -----Original Message----- But once the workbook is closed, it won't reach the last line and close Excel. -----Original Message----- ActiveWorkbook.Close SaveChanges:=False -----Original Message----- 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. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shared Workbook User had unsaved information disappear | Excel Worksheet Functions | |||
| Closing a workbook | Excel Discussion (Misc queries) | |||
| How to recover unsaved workbook? | Excel Discussion (Misc queries) | |||
| Dialog box when closing an unsaved spreadsheet | Excel Discussion (Misc queries) | |||
| closing workbook | Excel Programming | |||
![Mike[_64_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
