Is there a macro (or other method) that can be used to
print off every worksheet within a workbook, without
manually clicking on each sheet then using File -> Print??
Thanks,

To make my need as easy to explian as possible , I'm simplifing as much as
possible:
I have a worksheet with a rows with 4 columns  (these are options that we
add to a quote and entered manually based on quote needs.

I have a HP 540 C  printer.
I can't print anything from Word or Excel, neither from the Notepad.
No problem anyhow when printing an email from Hotmail, a PDF file from
Acrobat Reader.

If there is anyone out there (reading this) with Windows XP (preferably
Windows XP professional) and Office XP, and access to a _color_ laser
printer, preferably a brand name like HP or Xerox, with up-to-date printer
drivers....I'd really appreciate you taking 5 minutes to try to

I posted this to both the Excel.misc and powerpoint newsgroups, and no-one
confirmed this as a know issue- this is my last try before figuring out how
to report a bug to MS (see my last comment below)....
I have a _very_ simple chart in Excel XP. I copy/paste it to Powerpoint XP.

Hi, I'm fairly new to Excel, hope someone can help me out.
There was a question posted about printing a list of Invoices while
increasing the Invoice Number with each Invoice printed. It was stated that
the print preview did ok and would increase with each Invoice displayed but

I have a user (A) who is tearing his hair out with excel printing.  
Theres an excel file created by another user (B) who can print it out
on legal just fine. If User A opens the excel file (it's on a shared
drive) he can view it perfectly but when he previews it with the same

I use a program that exports data into an excel worksheet.  Often the
contents of certain cells are quite large (textual quotes).  When I try and
print from excel, the contents do not print completely.  I format the cell
to wrap text.  I increase the width of the column, which helps ...

I am using OLE to access Excel.  What I need to do is open the Printer
Selection dialog  and store the printer name to a variable.
I can open the dialog by using:
oExcel:Dialogs(8):Show()

I'm trying to print quite big sheet from .xls (which contains macros and
formatted cells) on KX-P6500. While waiting for printing there is error on
printer, and after that one page is printed out (not completed) and no more.
Other application (such Word, Paint) prints well (this is ...

When I print autoshapes created in excell worksheets the dimensions of the
printed autoshapes do not correspond to the set dimensions. In fact they
differ in both the vertical and horizontal axis by a different factor. Can
anybody please help why is this so.

Say you have columns A & B only, with serveral pages
worth of data; rather than print the two columns only on
each page (the default), is there a way to print them,
say, three columns (A & B) - to a page, therefore  

Say you have columns A & B only, with serveral pages
worth of data; rather than print the two columns only on
each page (the default), is there a way to print them,
say, three columns (A & B) - to a page, therefore  

I have formatted some cells on a spreadsheet which I need
to print as black & white on a color printer.
I need to do this by setting the Black and White tick box
on the 'Sheet' tab of the File/Page Setup dialog.

I have tried to print a worksheet with the frontpage for
financial statements.  It was the third worksheet of the
file I was working in.  Both sheets of the financial
statements printed correctly, but the frontpage did not