It is hard to say without seeing the code, but it is a known problem
in Excel that anything related to Page Setup is quite slow, due at
least in part to the fact that Excel must communicate with the
printer, a slow connection.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Tue, 6 Jan 2009 20:06:10 +0100, "Ro477" wrote:

I use excel2002sp3 on WinXP. I have a macro which opens PageSetup and inputs
the settings, then prints 3 copies of the report concerned. It seems to run
much slower than other macros. Is this normal ? How can I get a macro to run
faster ?

Thanks ... Roger