Visual Basic Assessment

When a workbook is saved you want to check automatically whether it contains errors (e.g. #REF, etc) and warn the user if errors are found.

What would be the best way to do this?

• A:   Write an Excel formula
• B:   Write a macro and link it to a button
• C:   Write a macro and link it to an event

 A     B     C