+ Reply to Thread
Results 1 to 3 of 3

Macro to prevent printing specific sheet based on cell value in another sheet

  1. #1
    Registered User
    Join Date
    06-24-2013
    Location
    Dallas, PA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Macro to prevent printing specific sheet based on cell value in another sheet

    I have a checklist as a tab name with checkboxes on the sheet. If all boxes are checked, the value of cell r33 will be 7 (adding the 7 checkboxes as valued true - each equals one). I want to prevent printing another tab named Invoice if that cell value does not = 7.
    THANKS!

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Macro to prevent printing specific sheet based on cell value in another sheet

    Hi, dbrady01,

    you would need to elaborate if you want to print via VBA or just using the normal print commands. If itīs the latter you may add the following code to ThisWorkbook (you would need to alter the name of the worksheet for the checkbox sum):
    Please Login or Register  to view this content.
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Registered User
    Join Date
    06-24-2013
    Location
    Dallas, PA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Macro to prevent printing specific sheet based on cell value in another sheet

    This worked! I had mine reading the IF as the cell value and the THEN as cancel print, but it would'nt work. Thanks a ton.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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