Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBScript to prompt Save on Cancel click
Hello everyone! I am dabbling in some VBScripting and created a simple form. What want to do is add an extra couple of code for the CANCEL button so tha when its clicked it will prompt the user to save the document - whethe they have changed it or not (cos I figure its easier that way!). This is all the code i have for the cancel button: Code ------------------- Private Sub cmdCancel_Click() Unload Me End Su ------------------- Any help on this would be much appreciated. Regards -- papercli ----------------------------------------------------------------------- paperclip's Profile: http://www.excelforum.com/member.php...fo&userid=3221 View this thread: http://www.excelforum.com/showthread.php?threadid=56673 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot seem to Cancel EXCEL App Right Click Event using C# | Excel Programming | |||
save prompt for user exit, but no save prompt for batch import? | Excel Discussion (Misc queries) | |||
Save an excel file in vbscript without user prompt | Excel Programming | |||
How to CANCEL file SAVE PROMPT when MACRO is running? | Excel Discussion (Misc queries) | |||
Cancel Macro is user selects 'cancel' at save menu | Excel Programming |