Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Print Question

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Good Afternoon,
    I am trying to find how to "mark" the contents of a cell or row so that I can see the contents on the screen but when I print the document, the contents are hidden. I don't want to hide the row. Is there any other way I can do this?

    Many thanks


  2. #2
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-19 07:40, Aargh!! wrote:
    Good Afternoon,
    I am trying to find how to "mark" the contents of a cell or row so that I can see the contents on the screen but when I print the document, the contents are hidden. I don't want to hide the row. Is there any other way I can do this?

    Many thanks
    You can do this in VBA. How are you planning on "marking" the rows you don't want to print?
    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Within Lotus, I understand it is possible to "mark" the cell contents with " ¦¦ " and this allows contents to be seen but not printed. Is this VBA method fairly simple / idiot proof? It'll need to be!
    Thanks again

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  5. #5
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-19 08:49, Aargh!! wrote:
    Within Lotus, I understand it is possible to "mark" the cell contents with " ¦¦ " and this allows contents to be seen but not printed. Is this VBA method fairly simple / idiot proof? It'll need to be!
    Thanks again
    In attempting to come up with a solution, I have identified a potential problem. I can easily hide a row before printing, but the user would have to manually unhide the rows after printing (not idiot proof). If you'd like, I can provide the code to hide a row before printing.


    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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