Some of the properties in PageSetup can take a while. It's just their
nature! Setting header text is high on the list and so some folks use
XLM4 macros to do things because it's much faster being that it's not
VBA. You can get code sample for using this alternate approach from
John McGimpsey's website. The original code was by John Green but JM
has reworked it to be quite a bit more friendly. I highly recommend you
use this for all pagesetup needs as it can set all possible properties
in a few seconds. Since it's XLM4 it's fairly old so any missing
properties we have today will have to be done in the usual way.

Here's a link...

http://www.mcgimpsey.com/excel/udfs/pagesetup.html

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc