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

[Dan Gardner]

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

[richardreye]

There is a workbook event called BeforeSave. Check the Visual Basic Help or this Forum on BeforeSave.

Cheers!

[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

Dan Gardner wrote:
>
> 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