View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default PageSetup is slow

After you use it try

ActiveSheet.DisplayPageBreaks = False

--
Regards,
Tom Ogilvy


"Christof DB" wrote in message
...
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