LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
print grayscale on multiple sheet workbook Electric Julie[_2_] Excel Discussion (Misc queries) 1 July 30th 09 09:40 PM
How do I set a print area for every sheet in the workbook? scru_ball Excel Discussion (Misc queries) 3 February 3rd 09 11:59 PM
How to print entire workbook 9 pages to a sheet? JDS Excel Worksheet Functions 7 July 14th 08 09:47 PM
Print only 1 sheet in a workbook. [email protected] Excel Discussion (Misc queries) 9 February 18th 07 04:20 PM
How can I print page 2 of each sheet in a workbook? sflower Excel Discussion (Misc queries) 1 March 9th 05 02:15 PM


All times are GMT +1. The time now is 09:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright Š2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"