print one sheet of workbook

  • Thread starter Thread starter Buddy Lee
  • Start date Start date
B

Buddy Lee

Hi

I have a workbook with many worksheets and I need to write a macro that
prints only one unselected sheet ( or a named range ). I found help for
xlDialogPrint but I don't understand it :( I need to disable some choices in
this dialog. Is it possible? Arguments for this dialog box are : range_num,
from, to, copies, draft, preview, print_what, color, feed, quality,
y_resolution, selection, printer_text, print_to_file, collate
 
Back
Top