| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Close Workbook without displaying message to Save
Hello:
I have a User form with a button labelled "CLOSE" which closes the form as well as Quits the application. How I can prevent the Excel Message which ask whether the user wants to save the file? I would like to close the file without saving TIA |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Close Workbook without displaying message to Save
Hi
try application.displayalerts=false activeworkbook.close application.displayalerts=True -- Regards Frank Kabel Frankfurt, Germany Vinay wrote: Hello: I have a User form with a button labelled "CLOSE" which closes the form as well as Quits the application. How I can prevent the Excel Message which ask whether the user wants to save the file? I would like to close the file without saving TIA |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Close Workbook without displaying message to Save
Workbooks("MyFile.xls").Saved = True
-- Regards, Tom Ogilvy "Vinay" wrote in message om... Hello: I have a User form with a button labelled "CLOSE" which closes the form as well as Quits the application. How I can prevent the Excel Message which ask whether the user wants to save the file? I would like to close the file without saving TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| close workbook without saving or promt to save | Excel Discussion (Misc queries) | |||
| If Formula for displaying a message | Excel Discussion (Misc queries) | |||
| Option in Excel to save a close a workbook inactive for 5 minutes | Excel Discussion (Misc queries) | |||
| Warning message on file close | Excel Worksheet Functions | |||
| When I try to save a workbook, I get the message "document has no. | Excel Discussion (Misc queries) | |||
![Vinay[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
