| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| print grayscale on multiple sheet workbook | Excel Discussion (Misc queries) | |||
| How do I set a print area for every sheet in the workbook? | Excel Discussion (Misc queries) | |||
| How to print entire workbook 9 pages to a sheet? | Excel Worksheet Functions | |||
| Print only 1 sheet in a workbook. | Excel Discussion (Misc queries) | |||
| How can I print page 2 of each sheet in a workbook? | Excel Discussion (Misc queries) | |||
Linear Mode
