Thread: PageSetup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
fred fred is offline
external usenet poster
 
Posts: 73
Default PageSetup

Setting the properties of the pagesetup object (e.g. LeftHeader,
RightHeader, LeftMargin etc, etc) seems to take a long time.
Is there a way to speed this up? The turning the Application.ScreenUpdating
off doesn't help nor does switching the Application.Calculation to manual
but is there something like this to speed up the pageSetup
properties/methods.

Thanks for any help
Fred