he OnWorkbookBeforePrint provides facilities for trapping an event fired by
Excel before directing information to a printer. Consider the following code.
The output of the signature() method indicates that an event handler is
expected to accept one argument and return a boolean value. If the last
processed event handler returns True then the printing (or opening Print
dialog) will be stopped. The following code illustrates the ideas.
Consequently, any output to a printer would be stopped and an attempt would
direct output to the ControlShell as show below.