Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display Print Dialog with Selection: Excel 2003
I am using Application.Dialogs(xlDialogPrint).Show
to display the print dialog. How do I activate "Selection" under Print What? -- Colleen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display Print Dialog with Selection: Excel 2003
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: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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display Print Dialog with Selection: Excel 2003
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" wrote in message ... 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: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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display Print Dialog with Selection: Excel 2003
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" wrote in message ... 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: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 . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display Print Dialog with Selection: Excel 2003
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" wrote in message ... 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" wrote in message ... 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: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 . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display Print Dialog with Selection: Excel 2003
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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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: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 . |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display Print Dialog with Selection: Excel 2003
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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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: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 . |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display Print Dialog with Selection: Excel 2003
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" wrote in message ... 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: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 . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you do a range selection dialog like those many in Excel? | Excel Discussion (Misc queries) | |||
How do you do a range selection dialog like those many in Excel? | Excel Programming | |||
The file association dialog won't allow selection of Excel | Setting up and Configuration of Excel | |||
Print dialog box selection macro | Excel Discussion (Misc queries) | |||
excel print dialog | Excel Programming |