Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
save on exit message box
Is their a way to display a message box, when the user click to exit
the worksheet using a macro? The user will have 3 options Yes, No, Cancel. How can I program this using VBA in Ms Excel XP? ------------------------------------------------ The code I use at the moment saves the worksheet without asking the user: Sub CloseSpreedsheet() 'Saves spreedsheet ThisWorkbook.Saved = True 'Closes the application Application.Quit End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i get the option to save changes when i exit | Excel Discussion (Misc queries) | |||
Why does Excel ask to Save on Exit? | Excel Discussion (Misc queries) | |||
Automatic Save and Exit | Excel Discussion (Misc queries) | |||
On Exit, always asked to save | Excel Worksheet Functions | |||
Save & Exit | Excel Worksheet Functions |