Quitting a BeforeSave event procedure without saving.

[Richard Buttrey]

In a Workbook BeforeSave procedure, I've got a Message box to which I
expect a Yes/No response.

If the answer is No then I want to simply quit the procedure without
the workbook saving. It seems that whether the answer is Yes or No,
the procedure continues to the end and saves the workbook.

I've tried putting an Exit Sub, or End command after the test but to
no avail.

Can anyone help me out please.

Usual TIA

Rgds,

Richard Buttrey

 

[Frank Kabel]

Hi
add the line
Cancel = True

 

[Richard Buttrey]

Brilliant,

Many thanks Karl.





*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!