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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print page one of sheet only 4
Excel VBA - Problem with Closing Print Preview 0
print 2 sheets on one paper 5
Macro for all Excel Workbooks to print to PDF 2
Error Message - Macro to Unlink MS Queries from Workbook 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Printing Macro 4
Macro for multiple prints 4

Back
Top