| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLDialog for setting the Print Area of a worksheet
Hi,
can anyone point me in the direction of which XLDialog can set the PrintArea of a worksheet from VBA (with no user entry) - I want to use the Show method and pass in the arguments thanks Philip |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
XLDialog for setting the Print Area of a worksheet
hi
in xl help type "built-in dialog box arguments lists" there isn't a xldialog for print_area only. excel conciders print_area as a named range and Print_area shows up in the xldialogDefineName dialog box. the name "Print_Area" is an excel reserved name. in a macro, print_area is set like ActiveSheet.PageSetup.PrintArea = "$A$1:$E$44" or if pre-selected ActiveSheet.PageSetup.PrintArea = selection regards FSt1 "Philip" wrote: Hi, can anyone point me in the direction of which XLDialog can set the PrintArea of a worksheet from VBA (with no user entry) - I want to use the Show method and pass in the arguments thanks Philip |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
XLDialog for setting the Print Area of a worksheet
excuse.
look up built-in dialogs in VB help not XL help sorry FSt1 "FSt1" wrote: hi in xl help type "built-in dialog box arguments lists" there isn't a xldialog for print_area only. excel conciders print_area as a named range and Print_area shows up in the xldialogDefineName dialog box. the name "Print_Area" is an excel reserved name. in a macro, print_area is set like ActiveSheet.PageSetup.PrintArea = "$A$1:$E$44" or if pre-selected ActiveSheet.PageSetup.PrintArea = selection regards FSt1 "Philip" wrote: Hi, can anyone point me in the direction of which XLDialog can set the PrintArea of a worksheet from VBA (with no user entry) - I want to use the Show method and pass in the arguments thanks Philip |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
XLDialog for setting the Print Area of a worksheet
Thanks, that's good.
"FSt1" wrote: hi in xl help type "built-in dialog box arguments lists" there isn't a xldialog for print_area only. excel conciders print_area as a named range and Print_area shows up in the xldialogDefineName dialog box. the name "Print_Area" is an excel reserved name. in a macro, print_area is set like ActiveSheet.PageSetup.PrintArea = "$A$1:$E$44" or if pre-selected ActiveSheet.PageSetup.PrintArea = selection regards FSt1 "Philip" wrote: Hi, can anyone point me in the direction of which XLDialog can set the PrintArea of a worksheet from VBA (with no user entry) - I want to use the Show method and pass in the arguments thanks Philip |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting Print Area | Excel Programming | |||
| setting print area | Excel Programming | |||
| Help with setting Print area to more than one worksheet with VBA | Excel Programming | |||
| setting print area via VBA | Excel Programming | |||
| Setting print area | Excel Programming | |||
Linear Mode
