View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How do I set print areas for multiple sheets simultaneously?

Ps. You have to group the worksheets that should have the same print area
before running the macro.

Click on the first worksheet tab and ctrl-click on subsequent.

And after, rightclick on one of the grouped sheets and select ungroup sheets.

Twirly wrote:

How do I set identical print areas for multiple sheets in the same workbook
simultaneously?


--

Dave Peterson