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
|