Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    271

    Unanswered: I don't want a cell to print


    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
    Gotta to do some code

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    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.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Mar 2004
    Location
    Fort Worth, Texas, USA
    Posts
    68
    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.

Posting Permissions

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