View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default Display Print Dialog with Selection: Excel 2003

Not sure I understand the question, but the Selection option would apply to
a range that was selected prior to displaying the dialog box. i.e. If you
had selected Range("A1:D10") prior to opening the Print dialog box, you
would simply select the "Selection" option and it would print that range.
You cannot make the selection after you have opened the dialog box.


"Colleen M" wrote in message
...
I am using Application.Dialogs(xlDialogPrint).Show
to display the print dialog.

How do I activate "Selection" under Print What?
--
Colleen