I don't want a cell to print

surfacesys · #1 (**permalink**) 05-07-04, 13:38

I have a cell that has the filename showing. This is to help the person using the workbook to know what workbook they are working in. I know it sounds dumb, but we have some real rookies!!

I would like this cell to not print when we print the form.
Is there a way to do that.
I can do it with a combo box or button. I just can't find out about a cell

Michael

shades · #2 (**permalink**) 05-07-04, 14:22

You can do it in a couple of ways. Perhaps the easiest is to attach a macro to a print button on the sheet. The macro would do two things:

1. Change the color of the font to match the background. So for instance, if the font is black, and the background of the cell is white, then you could include your print command, the change the cell font back again.

Code:

Sub NotPrintCell()
    'This will change the font of the cell to white
    Range("A1").Font.ColorIndex = 2
    'This will initiate the Print command
    ActiveWindow.SelectedSheets.PrintOut Collate:=True
    'This will change the font of the cell back to black
    Range("A1").Font.ColorIndex = 1
End Sub

Adjust your ColorIndex Numbers as needed, and your Print command as needed.

actuary · #3 (**permalink**) 05-08-04, 12:27

Have you notified your rookies that the filename is in the title bar?

On Soapbox:
When we tax (or punish) behavior, we get less of it. When we reward behavior, we get more of it.
Your efforts are rewarding ignorance: please, please consider "smarting up your users" rather than "dumbing down the interface".
:Off Soapbox

Or, you can just put the cell with the filename above the print range.

Internet Services

Web Development

Digital Marketing

Consumer Tech