Protect a sheet from Printing within a workbook?

[Ratedr]

I am making an ordering spreadsheet for my customers. On one sheet,
there is every style # of THEIRS, with the corresponding style # of
MINE (to preface, my customers refuse to make my life easier by
ordering with our style #s, so I have to make up 20 of these sheets
for various large customers..but thats beside the point).

Again, on one sheet, is about 1000 style #s in two columns (their #
and my #)

The second and third sheets, are the ones that they are going to use
to send in orders to me. When they email me an order, my computer is
set to automatically print out the xls files attached to them (kind of
like a computer fax machine, etc). However, I dont want every time
they send an order, to print both the order sheet they want to send to
me, as well as the 15-20 page sheet of style #s.

So I ask: is there a way to set something so that that first sheet
with NOT print? or on the reverse, set something to ONLY print those
other two?

 

[GS]

Ratedr presented the following explanation :

I am making an ordering spreadsheet for my customers. On one sheet,
there is every style # of THEIRS, with the corresponding style # of
MINE (to preface, my customers refuse to make my life easier by
ordering with our style #s, so I have to make up 20 of these sheets
for various large customers..but thats beside the point).

Again, on one sheet, is about 1000 style #s in two columns (their #
and my #)

The second and third sheets, are the ones that they are going to use
to send in orders to me. When they email me an order, my computer is
set to automatically print out the xls files attached to them (kind of
like a computer fax machine, etc). However, I dont want every time
they send an order, to print both the order sheet they want to send to
me, as well as the 15-20 page sheet of style #s.

So I ask: is there a way to set something so that that first sheet
with NOT print? or on the reverse, set something to ONLY print those
other two?

Can you hide the style conversion sheet? If so then it shouldn't print
unless your code forces it to.

 

[GS]

I forgot to mention...

NORMALLY SPEAKING, consumers order from vendors using the vendor item
#s, NOT THEIR #s. That said, don't you think you could set them
straight about how that works so life is easier for both?<g>

 

[Ratedr]

can you explain the hiding the sheet thing further? they are on two
different sheets on the same workbook, but I only want it to print one
sheet. Would you recommend I put all of the style conversion sheet on
the same page, but way down at the bottom, and hide it? will that
print a bunch of blank pages?

 

[GS]

Ratedr formulated the question :

can you explain the hiding the sheet thing further? they are on two
different sheets on the same workbook, but I only want it to print one
sheet. Would you recommend I put all of the style conversion sheet on
the same page, but way down at the bottom, and hide it? will that
print a bunch of blank pages?

No!

My understanding of your post is there are 3 sheets in the file; 1
sheet contains the styles cross-reference, 2 sheets are for orders. You
can hide the styles sheet so only the 2 order sheets are visible.
Visible sheets are all that print. Is there any reason why you can't
hide the styles sheet? If this sheet is just for reference then why not
put THEIR style #s in a cell dropdown on the order sheet, and use a
formula to insert YOUR style #s in another column.

I'm curious why you have 2 order sheets. It's hard to imagine why you
need 2, and confusing why you say you only print 1 sheet. Are there
instructions for using this file? Can you attach a copy of it to your
reply so we can see what you're trying to accomplish?

 

[Ratedr]

disregard any questions, I figured it out. There are only 2 sheets:

1 with the cross reference
1 which will be an actual order sheet where they type their style #
and ours comes up, then Im going to have them email it to me.

I dont want to print the cross reference sheet, I only want the order
sheet to go to my factory..but I hid the sheet, and now it is not
going to print.

As far as a few comments ago, in an ideal world, you are correct, they
need to use my style #s...however, for 55 years before me, they have
allowed customers to not have to think, and do whatever they want. It
might be because less than 20% of my customers are American, and about
that same % have the ability to use a computer (I have customers that
still call up and order because they refuse to buy a fax machine or a
computer)

 

[Ratedr]

I guess now my only issue is searching around finding out how to add a
button to the sheet that will automatically email the sheet to a
specific email address

 

[Gord Dibben]

All you want to know about emailing from Excel can be found at Ron de Bruin's
site.

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

Download the SendMail add-in for easiest method.


Gord Dibben MS Excel MVP