ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing a group of worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/193274-printing-group-worksheets.html)

Pat Adams

Printing a group of worksheets
 
I need to be able to print a certain group of worksheets within a workbook on
a consistent basis (actually there will be several groups). Can I set up
these groups so that I don't have to select the worksheets individually each
time I need to print?

Dave Peterson

Printing a group of worksheets
 
Record a macro when you
Select/group the worksheets to print
print the sheets
ungroup the sheets

Record as many as you need. Give the macros nice names so that you can
distinguish between them.

Pat Adams wrote:

I need to be able to print a certain group of worksheets within a workbook on
a consistent basis (actually there will be several groups). Can I set up
these groups so that I don't have to select the worksheets individually each
time I need to print?


--

Dave Peterson


All times are GMT +1. The time now is 02:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com