ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   XLDialog for setting the Print Area of a worksheet (https://www.excelbanter.com/excel-programming/416834-xldialog-setting-print-area-worksheet.html)

Philip

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

FSt1

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


FSt1

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


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