View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default .PageSetup on multiple sheets in workbook

Due to the slowness encountered using the .PageSetup in Excel, I was
attempting to do a one-shot setup as opposed to doing a setup per page. The
macro code is only setting up the active sheet when multiple sheets are
selected. However, if I do it manually, it sets up all the sheets at once.
Is this a glitch with VBA or is there code to get it to work properly?