How to disable the save dialog box and avoid workbook to close

Hi,

I hope somebody is able to help me with the following issue.

I have made a userform in VBA which pops-up as soon as the the Excel workbook tries to close when activating the red X-button. The userform has 3 buttons "Cancel", "Yes", "No".

When button "No" is activated the following must happen: The userform is unloaded and the user is guided to a certain cell to enter further information.
It works except that the normal save dialog ("Save", "Don't save", "Cancel") pops-up. I do NOT want this to happen.

Here is the code I have used so far:
'------ In the userform ------------

Please Login or Register  to view this content.

'------ ThisWorkbook ------------

Please Login or Register  to view this content.

What code can I put in to avoid the save dialog box to come up? (It is OK that it comes up when button "Cancel" is used. When button "Yes" is used I have used a code that will automatically save and close the workbook - this part works OK).

BR

Set Cancel to True, to cancel the the requested close process

Please Login or Register  to view this content.

Ok.

Declare and use a public variable for which you set the value in the form depending on the button clicked by the user. Then in the worksheet_BeforeClose routine you can use the value of that variable to determine whether Cancel should be set to True or False.

Good to hear that you managed to solve it.