| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving
How can I make a workbook close without prompting to save? This file has many links to other workbooks, and it has many viewers. Thanks -- DRANDON ------------------------------------------------------------------------ DRANDON's Profile: http://www.excelforum.com/member.php...o&userid=35901 View this thread: http://www.excelforum.com/showthread...hreadid=566107 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Saving
I take it that you do NOT want changes saved. If that's right, enter
this code in the ThisWorkbook module. James Private Sub Workbook_BeforeClose(Cancel As Boolean) ThisWorkbook.Saved = True End Sub DRANDON wrote: How can I make a workbook close without prompting to save? This file has many links to other workbooks, and it has many viewers. Thanks -- DRANDON ------------------------------------------------------------------------ DRANDON's Profile: http://www.excelforum.com/member.php...o&userid=35901 View this thread: http://www.excelforum.com/showthread...hreadid=566107 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving file in CSV format | Excel Discussion (Misc queries) | |||
| Saving worksheet as webpage | Excel Discussion (Misc queries) | |||
| Problem saving the file after moving worksheets into another | Excel Discussion (Misc queries) | |||
| How do I stop Excel 2000 from saving file history from file that . | Excel Discussion (Misc queries) | |||
| Opening and saving Excel 2003 file from Excel 97. | Excel Discussion (Misc queries) | |||
Linear Mode
