| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to disable save message when I click the cross to close the file
Dear all,
When I close a excel file by click the cross on the left top corner, excel will prompt me to save the file or not. I want the excel not to save the file and not to prompt me to save. How can I disable the save message when I press the cross to close the excel file? Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to disable save message when I click the cross to close the file
Peter,
There is the Workbook_BeforeClose event: ThisWorkbook.Saved=True NickHK "hon123456" wrote in message ups.com... Dear all, When I close a excel file by click the cross on the left top corner, excel will prompt me to save the file or not. I want the excel not to save the file and not to prompt me to save. How can I disable the save message when I press the cross to close the excel file? Thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to disable save message when I click the cross to close the file
Thanks NickHK
NickHK 寫道： Peter, There is the Workbook_BeforeClose event: ThisWorkbook.Saved=True NickHK "hon123456" wrote in message ups.com... Dear all, When I close a excel file by click the cross on the left top corner, excel will prompt me to save the file or not. I want the excel not to save the file and not to prompt me to save. How can I disable the save message when I press the cross to close the excel file? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007: How do I disable the 'Do you wish to save changes to...' when I close an un changed file? | Excel Discussion (Misc queries) | |||
| Disable Auto save on Right Click | Excel Discussion (Misc queries) | |||
| Disable option save when close excel | Excel Programming | |||
| Disable Macros --> Close File | Setting up and Configuration of Excel | |||
| Close Workbook without displaying message to Save | Excel Programming | |||
Hybrid Mode
