PageSetup
 

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

PageSetup
 

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

"Fred" <leavemealone@home wrote in message
...
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