Preflighting Excel files

[martindaylor]

Is there a way to preflight (check for problems before
printing) Excel files (I already know that Flightcheck
doesn't work).

Any suggestions?

Martin

 

[Otto Moehrbach]

Martin
There is a Before_Print event macro that you can use for such checking.
Of course, that macro is blank. You would have to write in the necessary
code to do the checks you want. Can you list the checks and the criteria
for each? Writing the code is straight forward once you have listed the
checks and criteria. HTH Otto