+ Reply to Thread
Results 1 to 2 of 2

Macro to stop the printer from printing if a cell is blank

  1. #1
    Registered User
    Join Date
    01-14-2015
    Location
    Florida, United States
    MS-Off Ver
    365
    Posts
    53

    Macro to stop the printer from printing if a cell is blank

    I am looking for a macro that will look at cell I2 and if it is blank, prompt the user to enter information before it prints. Basically, I don't want to be able to print the sheet unless I2 has information in it. Any help would be appreciated.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,717

    Re: Macro to stop the printer from printing if a cell is blank

    Put this in the ThisWorkbook module. Replace Sheet1 with whatever sheet you are talking about. Update message to user as desired.

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Replies: 1
    Last Post: 06-30-2017, 10:29 AM
  2. Printing with novaPDF printer using VBA macro.
    By surenMaharaj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-06-2015, 12:03 PM
  3. STOP PRINTING IF CELL is BLANK E.G B2 is blank then stop printing
    By gopising in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2014, 10:03 AM
  4. Stop printing blank cells with formula
    By Jasson in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 05-30-2013, 11:39 PM
  5. Replies: 0
    Last Post: 10-08-2005, 05:05 PM
  6. Choosing printer in a printing macro
    By \Jean-Jerome Doucet via OfficeKB.com\ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2005, 12:05 PM
  7. Choosing printer in a printing macro
    By Werner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2005, 11:52 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