Printing a group of worksheets

P

Pat Adams

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?
 
D

Dave Peterson

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.
 
Top