Prevent Printing of Specific Cells

Hi, folks. I'm looking for a way to format a cell so that the cell(s) will
_display_ on the worksheet, but not _print_ when the worksheet is printed.

I'm working on a sales worksheet. Some data on the worksheet, such as the
"dealer cost", need to be visible to the salesman and used in some
calculations, but if the salesman prints the worksheet, I don't want those
items to print.

Any thoughts?

Thanks.

Ken, have a look here for a way to do it,

http://www.rondebruin.nl/print.htm#Hide
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"Ken Mitchell" <Kenwd0elq(NOSPAM)@gmail.com> wrote in message
news:[email protected]...
> Hi, folks. I'm looking for a way to format a cell so that the cell(s)
> will
> _display_ on the worksheet, but not _print_ when the worksheet is printed.
>
> I'm working on a sales worksheet. Some data on the worksheet, such as the
> "dealer cost", need to be visible to the salesman and used in some
> calculations, but if the salesman prints the worksheet, I don't want those
> items to print.
>
> Any thoughts?
>
> Thanks.

Hmmm, I must not be doing it quite right.

I copied the appropriate sections of the code and ended up with

Private Sub Workbook_BeforePrint(Cancel As Boolean)
With ActiveSheet
.Rows("31:31").EntireRow.Hidden = True
.PrintOut
.Rows("31:31").EntireRow.Hidden = False
End With
End Sub

because I wanted to suppress printing for the cells in Row 31. Now it
prints the page twice; once with row 31 suppressed, and once with row 31
visible.

Any idea what I did wrong? Thanks.

"Paul B" wrote:

> Ken, have a look here for a way to do it,
>
> http://www.rondebruin.nl/print.htm#Hide
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
>
> "Ken Mitchell" <Kenwd0elq(NOSPAM)@gmail.com> wrote in message
> news:[email protected]...
> > Hi, folks. I'm looking for a way to format a cell so that the cell(s)
> > will
> > _display_ on the worksheet, but not _print_ when the worksheet is printed.
> >
> > I'm working on a sales worksheet. Some data on the worksheet, such as the
> > "dealer cost", need to be visible to the salesman and used in some
> > calculations, but if the salesman prints the worksheet, I don't want those
> > items to print.
> >
> > Any thoughts?
> >
> > Thanks.
>
>
>

Read the code Ken

I use this to cancel the normal print
Cancel = True


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ken Mitchell" <Kenwd0elq(NOSPAM)@gmail.com> wrote in message news:[email protected]...
> Hmmm, I must not be doing it quite right.
>
> I copied the appropriate sections of the code and ended up with
>
> Private Sub Workbook_BeforePrint(Cancel As Boolean)
> With ActiveSheet
> .Rows("31:31").EntireRow.Hidden = True
> .PrintOut
> .Rows("31:31").EntireRow.Hidden = False
> End With
> End Sub
>
> because I wanted to suppress printing for the cells in Row 31. Now it
> prints the page twice; once with row 31 suppressed, and once with row 31
> visible.
>
> Any idea what I did wrong? Thanks.
>
> "Paul B" wrote:
>
>> Ken, have a look here for a way to do it,
>>
>> http://www.rondebruin.nl/print.htm#Hide
>> --
>> Paul B
>> Always backup your data before trying something new
>> Please post any response to the newsgroups so others can benefit from it
>> Feedback on answers is always appreciated!
>> Using Excel 2002 & 2003
>>
>>
>> "Ken Mitchell" <Kenwd0elq(NOSPAM)@gmail.com> wrote in message
>> news:[email protected]...
>> > Hi, folks. I'm looking for a way to format a cell so that the cell(s)
>> > will
>> > _display_ on the worksheet, but not _print_ when the worksheet is printed.
>> >
>> > I'm working on a sales worksheet. Some data on the worksheet, such as the
>> > "dealer cost", need to be visible to the salesman and used in some
>> > calculations, but if the salesman prints the worksheet, I don't want those
>> > items to print.
>> >
>> > Any thoughts?
>> >
>> > Thanks.
>>
>>
>>

The Stupid Way:

Link conditional formatting to a cell value to change the font and
background color to what ever color you decide. Change the value of
the cell in code or manually before printing. After printing, change
the value back.

Aha! Thanks. I appreciate the help.

"Ron de Bruin" wrote:

> Read the code Ken
>
> I use this to cancel the normal print
> Cancel = True
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Ken Mitchell" <Kenwd0elq(NOSPAM)@gmail.com> wrote in message news:[email protected]...
> > Hmmm, I must not be doing it quite right.
> >
> > I copied the appropriate sections of the code and ended up with
> >
> > Private Sub Workbook_BeforePrint(Cancel As Boolean)
> > With ActiveSheet
> > .Rows("31:31").EntireRow.Hidden = True
> > .PrintOut
> > .Rows("31:31").EntireRow.Hidden = False
> > End With
> > End Sub
> >
> > because I wanted to suppress printing for the cells in Row 31. Now it
> > prints the page twice; once with row 31 suppressed, and once with row 31
> > visible.
> >
> > Any idea what I did wrong? Thanks.
> >
> > "Paul B" wrote:
> >
> >> Ken, have a look here for a way to do it,
> >>
> >> http://www.rondebruin.nl/print.htm#Hide
> >> --
> >> Paul B
> >> Always backup your data before trying something new
> >> Please post any response to the newsgroups so others can benefit from it
> >> Feedback on answers is always appreciated!
> >> Using Excel 2002 & 2003
> >>
> >>
> >> "Ken Mitchell" <Kenwd0elq(NOSPAM)@gmail.com> wrote in message
> >> news:[email protected]...
> >> > Hi, folks. I'm looking for a way to format a cell so that the cell(s)
> >> > will
> >> > _display_ on the worksheet, but not _print_ when the worksheet is printed.
> >> >
> >> > I'm working on a sales worksheet. Some data on the worksheet, such as the
> >> > "dealer cost", need to be visible to the salesman and used in some
> >> > calculations, but if the salesman prints the worksheet, I don't want those
> >> > items to print.
> >> >
> >> > Any thoughts?
> >> >
> >> > Thanks.
> >>
> >>
> >>
>
>
>