| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exiting WorkBook Save event
In the Workbook Save event I want to give the user the chance to abort
the save by responding to a YesNo MessageBox. I've got an integer variable called 'answer' which is set by the MessageBox, and have tried both the following lines of code, expecting that they might exit the save event but they don't. If answer = 7 Then End If answer = 7 Then Exit Sub Has anyone any idea how I can handle this. Regards __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO YOU GET EXCEL TO ASK IF YOU WANT TO SAVE A FILE ON EXITING | Excel Discussion (Misc queries) | |||
| Exiting Excel prompts for save | Excel Discussion (Misc queries) | |||
| Is there a way to Trigger a Macro on a workbook save event | Excel Programming | |||
| BeforeSave sub won't save another workbook when triggered by another event sub | Excel Programming | |||
| Automatically run VB code on workbook save event | Excel Programming | |||
Threaded Mode
