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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 12:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com