How do I suppress the printing of certain rows in a spreadsheet? If there is
not a value in a particular cell in the row I do not want the row to print.
--
Valerie

You can hide the rows without values and then print
--
Kevin Backmann


"Valerie" wrote:

How do I suppress the printing of certain rows in a spreadsheet? If there is
not a value in a particular cell in the row I do not want the row to print.
--
Valerie

Someone other than myself will be working in the spreadsheet. They have
limited ability and will basically be performing data entry and printing
only. There are about 500 rows in the spreadsheet. At any point in time
there may only be 25 rows with values scattered throughout the spreadsheet
that she would want to print.

I want her to be able to see all of the rows, yet only print those with
values. I don't want her to have to hunt & peck for the rows with values.
What would the easiest solution be?
--
Valerie


"Kevin B" wrote:

You can hide the rows without values and then print
--
Kevin Backmann


"Valerie" wrote:

How do I suppress the printing of certain rows in a spreadsheet? If there is
not a value in a particular cell in the row I do not want the row to print.
--
Valerie

I have a few code examples here
http://www.rondebruin.nl/print.htm

See the macro "Sub Hide_Print_Unhide()"


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Valerie" wrote in message ...
Someone other than myself will be working in the spreadsheet. They have
limited ability and will basically be performing data entry and printing
only. There are about 500 rows in the spreadsheet. At any point in time
there may only be 25 rows with values scattered throughout the spreadsheet
that she would want to print.

I want her to be able to see all of the rows, yet only print those with
values. I don't want her to have to hunt & peck for the rows with values.
What would the easiest solution be?
--
Valerie


"Kevin B" wrote:

You can hide the rows without values and then print
--
Kevin Backmann


"Valerie" wrote:

How do I suppress the printing of certain rows in a spreadsheet? If there is
not a value in a particular cell in the row I do not want the row to print.
--
Valerie

Hi Ron De Bruin,

I have used your Macros in Excel 2007 to supress printing of certain Rows

Private Sub Workbook_BeforePrint(Cancel As Boolean)

' Hide Row 1 to Row 5 when printing

If ActiveSheet.Name = "Adjustment" Then
Cancel = True
Application.EnableEvents = False
Application.ScreenUpdating = False
With ActiveSheet
.Rows("1:5").EntireRow.Hidden = True
.PrintOut
.Rows("1:5").EntireRow.Hidden = False
End With
Application.EnableEvents = True
Application.ScreenUpdating = True
End If
End Sub

However, after I clicked "Print Preview", all toolbar icons are disable for
selection.

When I take out the above Macro, selection becomes available.

Could you show me how to fix it.

Thanks.

Igbert Au-Yeung

"Ron de Bruin" wrote:

I have a few code examples here
http://www.rondebruin.nl/print.htm

See the macro "Sub Hide_Print_Unhide()"


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Valerie" wrote in message ...
Someone other than myself will be working in the spreadsheet. They have
limited ability and will basically be performing data entry and printing
only. There are about 500 rows in the spreadsheet. At any point in time
there may only be 25 rows with values scattered throughout the spreadsheet
that she would want to print.

I want her to be able to see all of the rows, yet only print those with
values. I don't want her to have to hunt & peck for the rows with values.
What would the easiest solution be?
--
Valerie


"Kevin B" wrote:

You can hide the rows without values and then print
--
Kevin Backmann


"Valerie" wrote:

How do I suppress the printing of certain rows in a spreadsheet? If there is
not a value in a particular cell in the row I do not want the row to print.
--
Valerie

Hello Valerie
Why not hide the relevant rows?
You could also envisage a programming solution.

HTH
Cordially
Pascal

"Valerie" a écrit dans le message de
news: ...
How do I suppress the printing of certain rows in a spreadsheet? If there
is
not a value in a particular cell in the row I do not want the row to
print.
--
Valerie

Wouldn't each row have to be selected to hide? I need something that would
be automatic.
--
Valerie


"papou" wrote:

Hello Valerie
Why not hide the relevant rows?
You could also envisage a programming solution.

HTH
Cordially
Pascal

"Valerie" a écrit dans le message de
news: ...
How do I suppress the printing of certain rows in a spreadsheet? If there
is
not a value in a particular cell in the row I do not want the row to
print.
--
Valerie

Autofilter for non-blanks then print.

Record a macro while doing this.


Gord Dibben MS Excel MVP

On Thu, 13 Sep 2007 07:54:01 -0700, Valerie
wrote:

Wouldn't each row have to be selected to hide? I need something that would
be automatic.