I have written a few programs. The problem is I want to be able to control
what page in the workbook gets printed.

You give no detail but have you tried holding down the contol keyusing the
mouse to select the deired sheet tabsprinting
--
Don Guillett
SalesAid Software

"zchuckz" wrote in message
...
I have written a few programs. The problem is I want to be able to control
what page in the workbook gets printed.

What do you consider as a "page"?

A range on a worksheet that fits on one printed page?

You could give that range a name then assign it to a print macro or just select
the range and FilePrintSelection.

Or a particular worksheet to print?


Gord Dibben MS Excel MVP


On Tue, 12 Dec 2006 10:00:00 -0800, zchuckz
wrote:

I have written a few programs. The problem is I want to be able to control
what page in the workbook gets printed.

Sorry, guess my info was lacking. on sheet 1 I have 3 printable pages. The
first page is a fill in form, the 2nd page takes those inputs and adds my
mark ups to them, the third page prints a change order to the customer with
totals from pages 1 and 2.
On the third page I would like the option of just that page printing with
out page 1 and 2 printing. Is there a code or formula to do this , also is
there way to to print a page and not show certain information?
I hope this was a little clearer.

Thanks, for your help. This site is great and I am learning quite a bit just
reading the posts.

"Don Guillett" wrote:


You give no detail but have you tried holding down the contol keyusing the
mouse to select the deired sheet tabsprinting
--
Don Guillett
SalesAid Software

"zchuckz" wrote in message
...
I have written a few programs. The problem is I want to be able to control
what page in the workbook gets printed.

Have you tried <File<Print Area<Set Print Area?

Regards.

Bill Ridgeway
Computer Solutions

"zchuckz" wrote in message
...
Sorry, guess my info was lacking. on sheet 1 I have 3 printable pages. The
first page is a fill in form, the 2nd page takes those inputs and adds my
mark ups to them, the third page prints a change order to the customer
with
totals from pages 1 and 2.
On the third page I would like the option of just that page printing with
out page 1 and 2 printing. Is there a code or formula to do this , also is
there way to to print a page and not show certain information?
I hope this was a little clearer.

Thanks, for your help. This site is great and I am learning quite a bit
just
reading the posts.

"Don Guillett" wrote:


You give no detail but have you tried holding down the contol keyusing
the
mouse to select the deired sheet tabsprinting
--
Don Guillett
SalesAid Software

"zchuckz" wrote in message
...
I have written a few programs. The problem is I want to be able to
control
what page in the workbook gets printed.

Well, without sounding totally stupid...NO....but then I have no idea how or
where to use it?

"Bill Ridgeway" wrote:

Have you tried <File<Print Area<Set Print Area?

Regards.

Bill Ridgeway
Computer Solutions

"zchuckz" wrote in message
...
Sorry, guess my info was lacking. on sheet 1 I have 3 printable pages. The
first page is a fill in form, the 2nd page takes those inputs and adds my
mark ups to them, the third page prints a change order to the customer
with
totals from pages 1 and 2.
On the third page I would like the option of just that page printing with
out page 1 and 2 printing. Is there a code or formula to do this , also is
there way to to print a page and not show certain information?
I hope this was a little clearer.

Thanks, for your help. This site is great and I am learning quite a bit
just
reading the posts.

"Don Guillett" wrote:


You give no detail but have you tried holding down the contol keyusing
the
mouse to select the deired sheet tabsprinting
--
Don Guillett
SalesAid Software

"zchuckz" wrote in message
...
I have written a few programs. The problem is I want to be able to
control
what page in the workbook gets printed.

Open the spreadsheet
Highlight the area to be printed (hold down left mouse button)
Click on <File<Print Area<Set Print Area

Regards.

Bill Ridgeway
Computer Solutions

"zchuckz" wrote in message
...
Well, without sounding totally stupid...NO....but then I have no idea how
or
where to use it?

"Bill Ridgeway" wrote:

Have you tried <File<Print Area<Set Print Area?

Regards.

Bill Ridgeway
Computer Solutions

"zchuckz" wrote in message
...
Sorry, guess my info was lacking. on sheet 1 I have 3 printable pages.
The
first page is a fill in form, the 2nd page takes those inputs and adds
my
mark ups to them, the third page prints a change order to the customer
with
totals from pages 1 and 2.
On the third page I would like the option of just that page printing
with
out page 1 and 2 printing. Is there a code or formula to do this , also
is
there way to to print a page and not show certain information?
I hope this was a little clearer.

Thanks, for your help. This site is great and I am learning quite a bit
just
reading the posts.

"Don Guillett" wrote:


You give no detail but have you tried holding down the contol
keyusing
the
mouse to select the deired sheet tabsprinting
--
Don Guillett
SalesAid Software

"zchuckz" wrote in message
...
I have written a few programs. The problem is I want to be able to
control
what page in the workbook gets printed.

Bill,
I just tried your suggestion and it worked great. Will that also work if i
choose "send to email reciepient as an attachment" as well?

Thanks again for your help!

"Bill Ridgeway" wrote:

Have you tried <File<Print Area<Set Print Area?

Regards.

Bill Ridgeway
Computer Solutions

"zchuckz" wrote in message
...
Sorry, guess my info was lacking. on sheet 1 I have 3 printable pages. The
first page is a fill in form, the 2nd page takes those inputs and adds my
mark ups to them, the third page prints a change order to the customer
with
totals from pages 1 and 2.
On the third page I would like the option of just that page printing with
out page 1 and 2 printing. Is there a code or formula to do this , also is
there way to to print a page and not show certain information?
I hope this was a little clearer.

Thanks, for your help. This site is great and I am learning quite a bit
just
reading the posts.

"Don Guillett" wrote:


You give no detail but have you tried holding down the contol keyusing
the
mouse to select the deired sheet tabsprinting
--
Don Guillett
SalesAid Software

"zchuckz" wrote in message
...
I have written a few programs. The problem is I want to be able to
control
what page in the workbook gets printed.

Gord, Thanks for responding. On the work sheet "sheet 1" I have 3 sections
that when I print, prints out in 3 pages. I tried the setb printb area as
suggested an it worked great. will this also work when I select "send to
email reciepient as an attachment" as well

"Gord Dibben" wrote:

What do you consider as a "page"?

A range on a worksheet that fits on one printed page?

You could give that range a name then assign it to a print macro or just select
the range and FilePrintSelection.

Or a particular worksheet to print?


Gord Dibben MS Excel MVP


On Tue, 12 Dec 2006 10:00:00 -0800, zchuckz
wrote:

I have written a few programs. The problem is I want to be able to control
what page in the workbook gets printed.

The "send to as attachment" will send the entire workbook.

"Send to Recipient" will give you the option of attaching entire workbook or
just current sheet as body of email.

To send just the selected range you would need VBA code which is provided by Ron
de Bruin.

http://www.rondebruin.nl/sendmail.htm

If you download his SENDMAIL add-in you will have all the options at your
fingertips.


Gord Dibben MS Excel MVP

On Fri, 15 Dec 2006 10:07:01 -0800, zchuckz
wrote:

Gord, Thanks for responding. On the work sheet "sheet 1" I have 3 sections
that when I print, prints out in 3 pages. I tried the setb printb area as
suggested an it worked great. will this also work when I select "send to
email reciepient as an attachment" as well

"Gord Dibben" wrote:

What do you consider as a "page"?

A range on a worksheet that fits on one printed page?

You could give that range a name then assign it to a print macro or just select
the range and FilePrintSelection.

Or a particular worksheet to print?


Gord Dibben MS Excel MVP


On Tue, 12 Dec 2006 10:00:00 -0800, zchuckz
wrote:

I have written a few programs. The problem is I want to be able to control
what page in the workbook gets printed.



Gord Dibben MS Excel MVP