View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
paperclip[_2_] paperclip[_2_] is offline
external usenet poster
 
Posts: 1
Default 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