before workbook save event

[Fwiz]

Hi all,

Just a quick question (hopefully its an easy one)

I have a before workbook save event that validates criteria before transferring information to another workbook, once the user has pressed the save button, I'd like the validation to check on the "before workbook save" event and then if the validation fails - how do I prevent the workbook from actually being saved?

any thoughts?

 

[Andrew Poulsom]

Use:

Cancel = True