XLDialog for setting the Print Area of a worksheet

[Philip]

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

 

[FSt1]

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

 

[FSt1]

excuse.
look up built-in dialogs in VB help not XL help

sorry
FSt1

 

[Philip]

Thanks, that's good.

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