print one sheet of workbook
 

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


--

icq 25372592

print one sheet of workbook
 

Hi Buddy

Look here for a few oneliners
http://www.rondebruin.nl/print.htm#Print

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Buddy Lee" wrote in message ...
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


--

icq 25372592

print one sheet of workbook
 

looks good, works perfectly :) thank you.

--

icq 25372592
"Ron de Bruin" pí¹e v diskusním pøíspìvku
...
Hi Buddy

Look here for a few oneliners
http://www.rondebruin.nl/print.htm#Print

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Buddy Lee" wrote in message
...
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


--

icq 25372592