Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Mar 2004
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Fill cell - on screen but not print (2002 SP-2)

    I would like to hid some fields on my screen but I don't want to print them. Is that possible?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Fill cell - on screen but not print (2002 SP-2)

    It all depends. Could you be a little more specific?

    I don't completely understand: if they are hidden they shouldn't print.

    Steve

  3. #3
    New Lounger
    Join Date
    Mar 2004
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fill cell - on screen but not print (2002 SP-2)

    I have forms and I need to change certain items each time I use them. I don't change all items. I would like to highlight the fields I change because I'm forgetting one of them. I don't want the highlighting to print. I only want to see it on the screen. Hide takes it off the screen too.

    Cynthia

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Fill cell - on screen but not print (2002 SP-2)

    One simple way might be to just put the items to be changed in another place (on another sheet perhaps). Where you currently print from yu can just reference the cells in the other location.

    Thus you can format the "new input" location anyway you want, since the printout only gets the value.

    Steve

  5. #5
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Fill cell - on screen but not print (2002 SP-2)

    You could highlight by placing autoshapes (rectangular) on the appropriate cells, and use a suitable fill color, setting the transparency property to 50% +, and setting the print property to false. The following code will apply such highlighting (yellow) to the current selection. <pre> Sub HighLight()
    Dim shp As Shape
    With Selection
    Set shp = ActiveSheet.Shapes.AddShape _
    (msoShapeRectangle, .Left, .Top, .Width, .Height)
    End With
    With shp
    .Fill.ForeColor.SchemeColor = 13
    .Fill.Transparency = 0.75
    .Line.Visible = msoFalse <font color=448800>'optional</font color=448800>
    .DrawingObject.PrintObject = False
    End With
    End Sub</pre>

    Andrew C

Posting Permissions

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