Is there a way to Trigger a Macro on a workbook save event

[Guest]

I have a macro that performs a bunch of database conformity checks, i.e.
proper input format into a excel database. I was wondering if there is a way
to trigger the macro when the user tries to save the workbook, and be able to
correct any errors found before the save event takes place
Hope it’s possible, and thanks for any help that can be offered

 

[Dave Peterson]

There's a workbook_beforesave event that you may want to tap into.

You could set "cancel=true" and stop the save.

Chip Pearson has a nice primer at:
http://www.cpearson.com/excel/events.htm