View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jayray jayray is offline
external usenet poster
 
Posts: 45
Default Macro for page setup of worksheets is slow

I have a macro (a standard for each ws in worksheets loop) that goes
through each sheet in a workbook and sets the page setups. Each setup
is nothing unusual, just the margins, orientation, zoom, black and
white, etc., whatever is on the Excell Page Setup menu. I've always
found that this sequence is slow, with each page taking more than a
second, even if I turn the ScreenUpdating off. Is there anything I can
do to speed up the sequence?