PageSetup is slow

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I notice that whenever I cange a poperty of the PageSetup object the macro gets much slower. I estimate that changing any PageSetup property takes about 1.5 seconds.

Have you also notived this behaviour? Is there an explanation? Is there a way around?

thanks,
Christof
 
Setting pagesetup in vba IS slow. You don't really need to do it though as once set for a worksheet, it stays that way. There's not really a workaround / speedier way to do it AFAIK
 
Hi Christof,
I notice that whenever I cange a poperty of the PageSetup object the macro gets much slower. I estimate that changing any PageSetup property takes about 1.5 seconds.

Have you also notived this behaviour? Is there an explanation? Is there a way around?
Click to expand...

Many people use the much faster XLM PAGE.SETUP function:

ExecuteExcel4Macro "=PAGE.SETUP(...)"

For details of all the parameters, download the macrofun help file from the MS Web site (search for macrofun or xlmacr8)

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk
 
After you use it try

ActiveSheet.DisplayPageBreaks = False

--
Regards,
Tom Ogilvy


Christof DB said:
I notice that whenever I cange a poperty of the PageSetup object the macro
Click to expand...
gets much slower. I estimate that changing any PageSetup property takes
about 1.5 seconds.
 
Back
Top