he OnWorkbookBeforeSave property provides facilities for trapping an event
fired by Excel before saving a workbook. Consider the following code.
The output of the signature() method indicates that an event handler is
expected to accept two arguments and return a boolean value. The boolean
argument indicates whether the action taken is "SaveAs" or "Save". If the last
processed event handler returns True then the saving (or opening Save(As)
dialog) will be stopped. The following code illustrates the ideas.
Consequently, any attempt to save would be stopped and the output would be
directed to the ControlShell as show below.