Slow Page Setup - ExecuteExcel4Macro?

[bartekR]

Does any one know how to achive the same thing as below

With ActiveSheet.PageSetup
.PrintArea = "$A$1:$b$80"
.FitToPagesWide = 1
.FitToPagesTall = 1
.PrintTitleRows = "$1:$1"
End With

by using faster ExecuteExcel4Macro or Application.Dialog(xlDialogPageSetup) ?

im am using excel 2003.

many thanks

 

[combo]

Macro sheet functions help (to download):

http://support.microsoft.com/kb/q143466/

Syntax:
ExecuteExcel4Macro "PAGE.SETUP(""Head",.....)"
For print area use SET.PRINT.AREA


combo

 

[bartekR]

Cheers Combo, That's exactly what i was looking for.