| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
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  10") prior to opening the Print dialog box, youwould 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" <(E-Mail Removed)> wrote in message news:6E8AB572-0511-443B-8595-(E-Mail Removed)... >I am using Application.Dialogs(xlDialogPrint).Show > to display the print dialog. > > How do I activate "Selection" under Print What? > -- > Colleen |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Sorry, I should have given more detail.
I have 3 control buttons in a spreadsheet. Each one selects a specific range in the sheet, then opens the Print dialog box. I would like to have the "Selection" box automatically selected so the user simply has to select the printer and number of copies (and not have to remember to choose to print the selection). -- Colleen "JLGWhiz" wrote: > 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 10") 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" <(E-Mail Removed)> wrote in message > news:6E8AB572-0511-443B-8595-(E-Mail Removed)... > >I am using Application.Dialogs(xlDialogPrint).Show > > to display the print dialog. > > > > How do I activate "Selection" under Print What? > > -- > > Colleen > > > . > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Application.Dialogs(xlDialogPrint).Show , , , , , , , , , , , 1 '-- Also, try it with 2, 3 and 4 and see what happens. -- Jim Cone Portland, Oregon USA (3 week free trial of "Special Print" Excel add-in) "Colleen M" <(E-Mail Removed)> wrote in message news:9A701B19-B5AA-4381-8D6D-(E-Mail Removed)... Sorry, I should have given more detail. I have 3 control buttons in a spreadsheet. Each one selects a specific range in the sheet, then opens the Print dialog box. I would like to have the "Selection" box automatically selected so the user simply has to select the printer and number of copies (and not have to remember to choose to print the selection). -- Colleen "JLGWhiz" wrote: > 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 10") 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" <(E-Mail Removed)> wrote in message > news:6E8AB572-0511-443B-8595-(E-Mail Removed)... > >I am using Application.Dialogs(xlDialogPrint).Show > > to display the print dialog. > > > > How do I activate "Selection" under Print What? > > -- > > Colleen > > > . > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Well, it shows the arguments for it, but somebody smarter than me will have
to show you how to use it. I have tried every conventional way to apply the argument for Selection and it will not take. I will try the knowledge base for more info, but for now it looks like the user will have to remember to click it in the dialog box. "Colleen M" <(E-Mail Removed)> wrote in message news:9A701B19-B5AA-4381-8D6D-(E-Mail Removed)... > Sorry, I should have given more detail. > > I have 3 control buttons in a spreadsheet. Each one selects a specific > range > in the sheet, then opens the Print dialog box. I would like to have the > "Selection" box automatically selected so the user simply has to select > the > printer and number of copies (and not have to remember to choose to print > the > selection). > -- > Colleen > > > "JLGWhiz" wrote: > >> 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 10") 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" <(E-Mail Removed)> wrote in message >> news:6E8AB572-0511-443B-8595-(E-Mail Removed)... >> >I am using Application.Dialogs(xlDialogPrint).Show >> > to display the print dialog. >> > >> > How do I activate "Selection" under Print What? >> > -- >> > Colleen >> >> >> . >> |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Hi Jim, I could swear that I had tried that syntax, but apparently it was
one that I missed. Thanks for the input and edification. "Jim Cone" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > > > Application.Dialogs(xlDialogPrint).Show , , , , , , , , , , , 1 > '-- > Also, try it with 2, 3 and 4 and see what happens. > -- > Jim Cone > Portland, Oregon USA > (3 week free trial of "Special Print" Excel add-in) > > > > > "Colleen M" <(E-Mail Removed)> > wrote in message > news:9A701B19-B5AA-4381-8D6D-(E-Mail Removed)... > Sorry, I should have given more detail. > > I have 3 control buttons in a spreadsheet. Each one selects a specific > range > in the sheet, then opens the Print dialog box. I would like to have the > "Selection" box automatically selected so the user simply has to select > the > printer and number of copies (and not have to remember to choose to print > the > selection). > -- > Colleen > > > "JLGWhiz" wrote: > >> 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 10") 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" <(E-Mail Removed)> wrote in message >> news:6E8AB572-0511-443B-8595-(E-Mail Removed)... >> >I am using Application.Dialogs(xlDialogPrint).Show >> > to display the print dialog. >> > >> > How do I activate "Selection" under Print What? >> > -- >> > Colleen >> >> >> . >> |
|
|
|
|
|||
|
Guest
Posts: n/a
|
I once spent a long time screwing with another dialog and some of what I learned stuck with me. At least Excel (most of the time) doesn't crash when you put in an incorrect value. -- Jim Cone "JLGWhiz" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... Hi Jim, I could swear that I had tried that syntax, but apparently it was one that I missed. Thanks for the input and edification. "Jim Cone" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > > > Application.Dialogs(xlDialogPrint).Show , , , , , , , , , , , 1 > '-- > Also, try it with 2, 3 and 4 and see what happens. > -- > Jim Cone > Portland, Oregon USA > (3 week free trial of "Special Print" Excel add-in) > > > > > "Colleen M" <(E-Mail Removed)> > wrote in message > news:9A701B19-B5AA-4381-8D6D-(E-Mail Removed)... > Sorry, I should have given more detail. > > I have 3 control buttons in a spreadsheet. Each one selects a specific > range > in the sheet, then opens the Print dialog box. I would like to have the > "Selection" box automatically selected so the user simply has to select > the > printer and number of copies (and not have to remember to choose to print > the > selection). > -- > Colleen > > > "JLGWhiz" wrote: > >> 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 10") 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" <(E-Mail Removed)> wrote in message >> news:6E8AB572-0511-443B-8595-(E-Mail Removed)... >> >I am using Application.Dialogs(xlDialogPrint).Show >> > to display the print dialog. >> > >> > How do I activate "Selection" under Print What? >> > -- >> > Colleen >> >> >> . >> |
|
|
|
|
|||
|
Guest
Posts: n/a
|
I think the software engineer who was developing that project must have left
the company before he put the finishing touches to it. "Jim Cone" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > > I once spent a long time screwing with another dialog and some of what I > learned stuck with me. > At least Excel (most of the time) doesn't crash when you put in an > incorrect value. > -- > Jim Cone > > > "JLGWhiz" <(E-Mail Removed)> > wrote in message news:(E-Mail Removed)... > Hi Jim, I could swear that I had tried that syntax, but apparently it was > one that I missed. Thanks for the input and edification. > > > > "Jim Cone" <(E-Mail Removed)> wrote in message > news:(E-Mail Removed)... >> >> >> Application.Dialogs(xlDialogPrint).Show , , , , , , , , , , , 1 >> '-- >> Also, try it with 2, 3 and 4 and see what happens. >> -- >> Jim Cone >> Portland, Oregon USA >> (3 week free trial of "Special Print" Excel add-in) >> >> >> >> >> "Colleen M" <(E-Mail Removed)> >> wrote in message >> news:9A701B19-B5AA-4381-8D6D-(E-Mail Removed)... >> Sorry, I should have given more detail. >> >> I have 3 control buttons in a spreadsheet. Each one selects a specific >> range >> in the sheet, then opens the Print dialog box. I would like to have the >> "Selection" box automatically selected so the user simply has to select >> the >> printer and number of copies (and not have to remember to choose to print >> the >> selection). >> -- >> Colleen >> >> >> "JLGWhiz" wrote: >> >>> 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 10") 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" <(E-Mail Removed)> wrote in message >>> news:6E8AB572-0511-443B-8595-(E-Mail Removed)... >>> >I am using Application.Dialogs(xlDialogPrint).Show >>> > to display the print dialog. >>> > >>> > How do I activate "Selection" under Print What? >>> > -- >>> > Colleen >>> >>> >>> . >>> > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Jim, worked like a charm, thanks!
-- Colleen "Jim Cone" wrote: > > > Application.Dialogs(xlDialogPrint).Show , , , , , , , , , , , 1 > '-- > Also, try it with 2, 3 and 4 and see what happens. > -- > Jim Cone > Portland, Oregon USA > (3 week free trial of "Special Print" Excel add-in) > > > > > "Colleen M" <(E-Mail Removed)> > wrote in message > news:9A701B19-B5AA-4381-8D6D-(E-Mail Removed)... > Sorry, I should have given more detail. > > I have 3 control buttons in a spreadsheet. Each one selects a specific range > in the sheet, then opens the Print dialog box. I would like to have the > "Selection" box automatically selected so the user simply has to select the > printer and number of copies (and not have to remember to choose to print the > selection). > -- > Colleen > > > "JLGWhiz" wrote: > > > 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 10") 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" <(E-Mail Removed)> wrote in message > > news:6E8AB572-0511-443B-8595-(E-Mail Removed)... > > >I am using Application.Dialogs(xlDialogPrint).Show > > > to display the print dialog. > > > > > > How do I activate "Selection" under Print What? > > > -- > > > Colleen > > > > > > . > > > . > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| selection in Print dialog not available | Anneen | Microsoft Word Document Management | 1 | 2nd Dec 2009 01:05 PM |
| Unable to display the user selection dialog. | Maziar Aflatoun | Microsoft Windows 2000 Applications | 1 | 4th Nov 2004 05:44 AM |
| Unable to display selection dialog (null) | Microsoft Windows 2000 Security | 1 | 27th Jul 2004 06:29 PM | |
| Unable to display the user selection dialog. | Maziar Aflatoun | Microsoft Windows 2000 Advanced Server | 1 | 7th May 2004 02:31 PM |
| unable to display the user selection dialog | AHMAD | Microsoft Windows 2000 Security | 1 | 29th Sep 2003 12:56 AM |
