| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print macro to bring up print options
Hi probably a stupid question but did know how to do this. What macro do I
need to bring up the printer dialog box? I have one that just prints but need to change paper type. Thanks in advance Nelly |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print macro to bring up print options
hi
there are a number of printer dialog boxes but the code to call any dialog is the same' Application.Dialogs(xlDialogPageSetup).Show the above lets you change paper size. i think. if not then curse my foul memory and try one of these...... xldialogprintersetup xldialogprintpreview xldialogPrint i think that's it. Regards FSt1 "Nelly" wrote: Hi probably a stupid question but did know how to do this. What macro do I need to bring up the printer dialog box? I have one that just prints but need to change paper type. Thanks in advance Nelly |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print macro to bring up print options
Sub kl()
prtSetUp = Application.Dialogs(xlDialogPrintPreview).Show End Sub "Nelly" wrote: Hi probably a stupid question but did know how to do this. What macro do I need to bring up the printer dialog box? I have one that just prints but need to change paper type. Thanks in advance Nelly |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print macro to bring up print options
On May 13, 2:06*pm, "Nelly" wrote:
Hi probably a stupid question but did know how to do this. What macro do I need to bring up the printer dialog box? I have one that just prints but need to change paper type. Thanks in advance Nelly Application.Dialogs(xlDialogPrint).Show |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print macro to bring up print options
You can probably do what you want with:
ActiveSheet.PrintOut(Preview:=True) "Nelly" wrote: Hi probably a stupid question but did know how to do this. What macro do I need to bring up the printer dialog box? I have one that just prints but need to change paper type. Thanks in advance Nelly |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print macro to bring up print options
Use it without parentheses
ActiveSheet.PrintOut Preview:=True "Nelly" wrote: Hi probably a stupid question but did know how to do this. What macro do I need to bring up the printer dialog box? I have one that just prints but need to change paper type. Thanks in advance Nelly |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print macro to bring up print options
Thanks for all the relies your stars ******
"JLGWhiz" wrote in message ... Use it without parentheses ActiveSheet.PrintOut Preview:=True "Nelly" wrote: Hi probably a stupid question but did know how to do this. What macro do I need to bring up the printer dialog box? I have one that just prints but need to change paper type. Thanks in advance Nelly |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print macro to bring up print options | Excel Programming | |||
| What are the options in the print macro? | Excel Programming | |||
| Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
| How to set DEFAULT print options in Excel to print gridlines? | Excel Discussion (Misc queries) | |||
| Need Help w/ Print Macro to Print All Visible Sheets (including Charts) in a Workbook | Excel Programming | |||
![Nelly[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
