multiple print setups in Excel workbook

[Newsgal]

Is there a way to create custom print setups for a Workbook used by multiple
users that each want a different print option?

 

[Gord Dibben]

Easy for a single worksheet using View>Custom Views and Include Print Settings.

Each user selects his Custom View and prints.

For multiple worksheets more difficult and I would say requires VBA

What type of print setups are you speaking of?

i.e. what would be included?


Gord Dibben MS Excel MVP

 

[Newsgal]

There are multiple worksheets in the workbook. Each worksheet is for a team
and specific portions of each worksheet track the individual reps'
performance on that team. This is the part I'm hoping to get a custom print
on so when the rep is in the workbook/worksheet they can print just their
performance totals.

 

[Gord Dibben]

You're saying that each team has its own worksheet but a rep may show up on more
than one sheet?

Or each team has its own worksheet and its own set of reps on that sheet?

If second case, Data>Filter>Autofilter should get you any single rep's data.

Print that.


Gord

 

[Newsgal]

Unfortunately the data isn't layed out so Data Filters can be used.

I was hoping I could use the custom View option, set up the views, and then
have users print fromt their view, but the worksheets don't display the
resize button that allows me to do this. Any other ideas?

 

[Gord Dibben]

Which "resize button" would that be?


Gord