On Jun 6, 12:15 pm, "Don Guillett" wrote:
Page setup macros ARE slow. Change ONLY what is necessary, not everything
OR, better yet use a Template sheet with the page setup done and copy that
one before putting in data.

--
Don Guillett
SalesAid Software
"jayray" wrote in message

ups.com...



I have a macro (a standard for each ws in worksheets loop) that goes
through each sheet in a workbook and sets the page setups. Each setup
is nothing unusual, just the margins, orientation, zoom, black and
white, etc., whatever is on the Excell Page Setup menu. I've always
found that this sequence is slow, with each page taking more than a
second, even if I turn the ScreenUpdating off. Is there anything I can
do to speed up the sequence?- Hide quoted text -

- Show quoted text -

I tried this approach, copying the text into VBE directly from the
website, and trimmed down some of the parameters (my Excel 2003 seemed
to think there were too many continuations), being careful as I did it
that I deleted both the Optional entry and the concatenated string
within the pgSetUp string. However, I find that the macro
PageSetupXL4M is not identified in the macro run form (Alt+F8), so I
cannot launch it. What am I doing wrong?