Run a macro before you save or print off

Is there a way to have a worksheet automatically run a macro before you save or print to do a check and stop the action if there is an error?

Example: If something is deleted that shouldn't be, it stops the save or print action and sends a message telling the user so they can fix it prior to avoid
a problem down the road?

Thanks!!

Open visual basic
select project explorer
right click on your workbook on the left hand side
select view code

on the left where it shows General select workbook
on the right select before save or before print.

Please Login or Register  to view this content.

At the bottom of your code if you want to stop the print or save function then enter "Cancel = True"

Please Login or Register  to view this content.

Originally Posted by mehmetcik

Open visual basic
select project explorer
right click on your workbook on the left hand side
select view code

on the left where it shows General select workbook
on the right select before save or before print.

Please Login or Register  to view this content.

At the bottom of your code if you want to stop the print or save function then enter "Cancel = True"

Please Login or Register  to view this content.

Worked like a charm!!! Thanks man!!