PageSetup

[Fred]

Setting the properties of the pagesetup object (e.g. LeftHeader,
RightHeader, LeftMargin etc, etc) seems to take a long time.
Is there a way to speed this up? The turning the Application.ScreenUpdating
off doesn't help nor does switching the Application.Calculation to manual
but is there something like this to speed up the pageSetup
properties/methods.

Thanks for any help
Fred

 

[Zone]

If you recorded the macro to do this, it would be worthwhile to go back and
remove all the lines in the code that aren't actually changing the page
setup. Those lines have to be executed, as well, so if you're just setting
the header for instance, remove all the lines that don't deal with the
header. That should speed things up. James