software

Hi Folks,

This is my first post here so appologies if I err with protocol.

I have a sheet with a main first page then a manual page break then
another page with manual break and one more, so I have 3 pages all
separated with manual breaks.
Excepting the first page, the other 2 pages can be hidden and unhidden
with a simple macro linked to a button. The problem is; when slecting
to print only the first 1 or 2 pages, obviously when visible, you get
the first page, which is good, but the remaining 1 or 2 come out and
are blank.

I have experiemented with random data on another sheet without macros
and the problem seems to be as soon as you add manual breaks to the
sheet, then any hidden section will always get printed out as blank.

Am I missing something?
I cannot use add-ins.

Thank you any help,

Dale--
D Poole
------------------------------------------------------------------------
D Poole's Profile: www.excelforum.com/member.php...oamp;userid=31391
View this thread: www.excelforum.com/showthread...hreadid=510897Nope. That's the way excel works.

But there are a few workarounds...

Copy the visible cells to a new worksheet and print that.

Copy all the cells to a new worksheet, remove the pagebreaks (and the hidden
rows) and print that.

Remove the page breaks, print, and reapply the page breaks.
D Poole wrote:
gt;
gt; Hi Folks,
gt;
gt; This is my first post here so appologies if I err with protocol.
gt;
gt; I have a sheet with a main first page then a manual page break then
gt; another page with manual break and one more, so I have 3 pages all
gt; separated with manual breaks.
gt; Excepting the first page, the other 2 pages can be hidden and unhidden
gt; with a simple macro linked to a button. The problem is; when slecting
gt; to print only the first 1 or 2 pages, obviously when visible, you get
gt; the first page, which is good, but the remaining 1 or 2 come out and
gt; are blank.
gt;
gt; I have experiemented with random data on another sheet without macros
gt; and the problem seems to be as soon as you add manual breaks to the
gt; sheet, then any hidden section will always get printed out as blank.
gt;
gt; Am I missing something?
gt; I cannot use add-ins.
gt;
gt; Thank you any help,
gt;
gt; Dale
gt;
gt; --
gt; D Poole
gt; ------------------------------------------------------------------------
gt; D Poole's Profile: www.excelforum.com/member.php...oamp;userid=31391
gt; View this thread: www.excelforum.com/showthread...hreadid=510897

--

Dave Peterson