+ Reply to Thread
Results 1 to 2 of 2

Prevent printing if Excel spreadsheet contains an error

  1. #1
    Banned User!
    Join Date
    09-26-2015
    Location
    Manchester
    MS-Off Ver
    2013
    Posts
    218

    Prevent printing if Excel spreadsheet contains an error

    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?

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Prevent printing if Excel spreadsheet contains an error

    Try pasting this into the ThisWorkbook tab in the VBA editor.

    Please Login or Register  to view this content.
    Martin

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Printing a spreadsheet in Excel 2010
    By lostsoul65 in forum Excel General
    Replies: 2
    Last Post: 09-24-2012, 09:47 AM
  2. Prevent making different copies of my excel spreadsheet
    By Renildrah in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-05-2011, 04:28 AM
  3. Stop an Excel spreadsheet from printing
    By Packman in forum Excel General
    Replies: 2
    Last Post: 04-13-2009, 12:31 AM
  4. [SOLVED] problem printing excel spreadsheet in pdf
    By ts in forum Excel General
    Replies: 0
    Last Post: 08-15-2006, 05:15 PM
  5. Not printing 0 in zipcodes from excel spreadsheet.
    By iamdevoe in forum Excel General
    Replies: 1
    Last Post: 12-22-2005, 11:50 AM
  6. Replies: 2
    Last Post: 11-16-2005, 06:20 PM
  7. How to prevent user from printing in Excel?
    By C Wayne in forum Excel General
    Replies: 3
    Last Post: 06-14-2005, 04:10 AM
  8. How to prevent copying of an order form using an excel spreadsheet
    By jerome in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-05-2005, 09:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1