Programming a UserForm Cancel Button

So I have a Userform. I have programmed it to pop up when a user attempts to close the workbook. Here is the code:

Please Login or Register  to view this content.

You will see that the code above shows the following command buttons: Save, End, and Cancel. I have managed to figure out how to get the save as dialog box to be displayed when a user clicks on the button SAVE with the code:

Please Login or Register  to view this content.

But I am completely and utterly stuck on the button CANCEL. If a user unintentionally or intentionally attempts to close the workbook and decides that he does not want to, how do I get the button CANCEL to stop the action and bring the user back to open workbook. Unload me only closes the userform and then still closes the workbook!

Can someone help?

Cheers,
Kaytie

Hi Kaytie ,

Try adding the following line anywhere in Workbook_Before():

Please Login or Register  to view this content.

Lewis

Thanks for answering my post, LJMetzger. So this is code I have:

Please Login or Register  to view this content.

Now what is the code that I need to use to program the END command button to save the file at the last known save location and close out the workbook altogether? Can you help me with this one too, LJMetzger? Anyone else willing to answer?

Thanks!

~Kaytie

So, sorry! My brain is so busy trying to get this done that it slipped my mind to come back and post the cross-post. Don't throw the book at me!

You all are killing me slowly! Why can I not figure this out for the life of me! Please, please someone tell me how to program a command code to save the workbook at its last known location and file name and close out excel. My brain is hurting and I want to scream in frustration!

Kaytie

So this is the code I am using for the END button:

Please Login or Register  to view this content.

And I get the following popup window from Visual Basic: "Run-time error '400: Form already displayed; can't show modally". I click on the DEBUG button and I am routed to the following code:

Please Login or Register  to view this content.

The line "frmUser.Show" is highlighted yellow. What the heck am I doing wrong?

~Kaytie

Yeah. No problem.

The purpose of the userform is to create a user log of the excel workbook. So when a user opens up the spreadsheet, he lands on Sheet1 entitled Instructions. Hopefully I can figure out a way to hide subsequent sheets. Once the user reads through the instructions, the user clicks on the command button entitled "Click here to display sheets in this workbook.". This opens up the userform. The user then inputs her first name, last name, and her employee's id. Then the user clicks on the START button. This inputs the information on Sheet5 and date and times stamp the information. The form closes. Here is the code for this process. So far it work spectacularly well thanks to Jim882.

Please Login or Register  to view this content.

Now I am working on the end. When the user is done with the review and attempts to close out the workbook, the userform is displayed with buttons to SAVE, END, and CANCEL. The user would use the CANCEL command button if he unintentionally or intentionally quits excel and either didn't want to or changes his mind. The SAVE command button displays excel's Save As dialogue box so they can save it where ever they want to on their computer. And then if the user selects the command button END, then I want excel to auto save the workbook, place a date and time stamp in Sheet5 Column F which is along side the date and time stamp when the user began her work, then close excel. The code that people have helped me come up with so far is:

Please Login or Register  to view this content.

The entire file is attached. Please, I am begging..... I NEED HELP WITH THIS. I am spinning my wheels here. Imagine me on a stage, on my knees begging the audience (you all). LOL

Cheers,
Kaytie

PLease see attached file

Please Login or Register  to view this content.

Please Login or Register  to view this content.