| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Close without "Do you want to save changes" prompt
Hello All
I would like to have a workbook that does not ask the user to save when closing. I don't need big security, I just want to do away with the prompt. Any assistance would be much appreciated. Paul |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Close without "Do you want to save changes" prompt
Hi Paul,
To *never* save changes, paste this into the ThisWorkbook module: Private Sub Workbook_BeforeClose(Cancel As Boolean) Me.Close SaveChanges:=False End Sub --- Regards, Norman "Paul" wrote in message ... Hello All I would like to have a workbook that does not ask the user to save when closing. I don't need big security, I just want to do away with the prompt. Any assistance would be much appreciated. Paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is it possible to disable "save" prompt in excel file on web server? | Excel Discussion (Misc queries) | |||
| Disallow "SAVE" only "SAVE AS" or prompt | Setting up and Configuration of Excel | |||
| MsgBox Prompt w/ No "X" to close | Excel Programming | |||
| Disable "Save" &/or "Close" | Excel Programming | |||
| How can I get "File Close" to prompt me to "Save Changes" ?? | Excel Programming | |||
Linear Mode
