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

Thanks for that information. I'll give it a try.

"Dave Peterson" wrote:

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