Dear Excelguru's,
Is it possible in VBA to define a certain printer tray
when I want to print a certain document?
We use several HP Laserjet4000 printers overhere.

OS : WIN XP PRO
PRINTER : EPSON LQ-670
Print out from excel will print 284.4@EJL at the top left
corner of the paper.

Can someone tell me if it is possible to set Excel up to print a large cell over two pages?  I have tried many times and Excel either pushes the entire cell onto the first or second page but not split it over both.
Thanks in advance.

My boss has made a request and I need help.  He has a
spreadsheet which has a list of names and he wants to be
able to just print selected names, not necessarily in
sequential rows or columns.  Every time I select a few

I want to shade columns B:F if the value in column A is ="X" for ease in
reading the print.
Any ideas?
TIA

Hi,
I wonder if any of you has seen this problem before, We
have 2 new Dell machines, running W2K Pro and Office 2K
Pro SR1, when the user runs Excel, i get reports of the

Does anyone know if it's possible to make Excel print headers and
footers in the original scale regardless of the print scaling of the
rest of the worksheets?
I am trying to print out some analysis worksheets and I have set every

I have a worksheet which contains some text boxes and a table that will fill
several pages one page wide and several down. I need to insert a manual page
break to force the pagination but when I do this (Insert:Page Break) it does not
make any difference. The page break is not ...

I'm using Excell 2000.
My problem is that i want to print on a page which size is like A4 but 5-6
cm longer what can i do?
Thanks in advande.

I have a multi-use print routine called via an addin's menu item.
The routine can identify which of three types of workbook it
is dealing with, and then process the print 'pages' accordingly.
What I would like to know is this:

After I print or preview an Excel, buttons, comboboxes &
other controls in the sheet move over to the left from
their normal positions.  Vertical position is unchanged.  
Version is 2002 10.6501.6626.

I am preparing an invoice template to print onto pre-
printed stationery. For the date field for example I need
to put the field description "Date:" so I know where to
type in the date but I don't want it to print as it is

OK. I use the following code to print two worksheets of a larger excel
file to .pdfs.  The code executes fine with no errors, but creates two
.pdfs that are 0kb in size and when I try to open them I get a message
that says: "A file read error has occured."

I'm having a repeating problem Lexmark X83
If anyone has encountered this problem and has discovered how to fix it (other
than re-installing the Lexmark Software), I would really appreciate your
posting a reply.

I am running win2k and trying to print multiple copies
from excel(v.9) to a HP inkjet 1100, and it won't!!
I can print multiple copies in Word fine but Excel won't
have any of it!!