Conditional Printing

[Soulfien]

I'm trying to make certain cells print only if they do not contain the value of "Case No." I want the whole page to print- just those specific calls to remain blank if their contents contain that value. So far, I've found about a dozen ways on how not to do it. That's the first step, right? Eliminate all the wrong ways and then you're left with the right way!

Conditional Formatting is not an option- the printer at this company will always print black text regardless of font color. I also found a module that will prevent the whole page from printing if the contents of those cells are "Case No.", but that's no good. I just need those cells to be blank.

Is there a VBA function that will take care of this?

[davesexcel]

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.



To add a file to a post

[Soulfien]

All right, I attached a copy of it- I removed several UserForms so that it wouldn't be too large for this forum. Max size allowed is 1M and it was 2.5M.

I need the cells that contain, "Case No.", "Serial Number", and "New Serial Number" to not print when they contain those values.

[davesexcel]

What do you mean by Print?
Are you referring to setting the print range?

[Soulfien]

When the user hits the "Print" button to send the document to a printer, I would like the cells I mentioned to show as blank on the paper if the cells have the default values.
I think I came up with a way to get that done. When I get a few minutes, I'll try and use a printer function to change the values to "" if they have the default values. This will be done right when the user prints the spreadsheet (I hope). Then it should print just fine.

[Soulfien]

It works!

In ThisWorkbook, I have:

Please Login or Register  to view this content.

And in a module, I have:

Please Login or Register  to view this content.

This makes it blank for the print and then restores the default values. To the user, it appears as if the default values simply don't print at all.