Hi All,

I have a feeling that this may somehow be linked with Macros, with which I am totally inexperienced, so if my hunch is righ please bear my limited Excel knowledge in this are in mind when answering. Thank you in advance.

Essentially I have a petty cash form which will be used in high volumes by all staff members. The forms allow the users to input data about advances received, input values on the purchase invoices, input values on change being returned etc. The form then summarises all this information in the form of a journal. The users will then print off the completed form and hand to a single person in the accounts department who will then process the journals as per the spreadsheet on the accounts system.
I cannot reasonably expect this one person to review the accuracy of each journal in detail before processing onto an accounts system, due to the high volumes of these sheets. Hence, I have tried to automate the spreadsheet as much as possible but it is not infallible to incorrect user entry. Hence I want to be able to introduce a function which prevents the user from printing if the Excel sheet contains any form of error e.g. #VALUE, #FALSE, #ERROR etc. etc.

Please can someone assist?