Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
multiple print setups in Excel workbook
Is there a way to create custom print setups for a Workbook used by multiple
users that each want a different print option? -- News Gal |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
multiple print setups in Excel workbook
Easy for a single worksheet using ViewCustom 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 On Tue, 1 Jul 2008 11:09:00 -0700, Newsgal wrote: Is there a way to create custom print setups for a Workbook used by multiple users that each want a different print option? |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
multiple print setups in Excel workbook
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. -- News Gal "Gord Dibben" wrote: Easy for a single worksheet using ViewCustom 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 On Tue, 1 Jul 2008 11:09:00 -0700, Newsgal wrote: Is there a way to create custom print setups for a Workbook used by multiple users that each want a different print option? |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
multiple print setups in Excel workbook
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, DataFilterAutofilter should get you any single rep's data. Print that. Gord On Tue, 1 Jul 2008 13:11:11 -0700, Newsgal wrote: 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. |
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
multiple print setups in Excel workbook
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? -- News Gal "Gord Dibben" wrote: 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, DataFilterAutofilter should get you any single rep's data. Print that. Gord On Tue, 1 Jul 2008 13:11:11 -0700, Newsgal wrote: 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. |
#6
Posted to microsoft.public.excel.setup
|
|||
|
|||
multiple print setups in Excel workbook
Which "resize button" would that be?
Gord On Wed, 2 Jul 2008 15:50:20 -0700, Newsgal wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
set default page setups for insert sheet in workbook | Excel Discussion (Misc queries) | |||
Print 1st Page Multiple Sheets in Same Workbook | Excel Discussion (Misc queries) | |||
Different print page setups on one worksheet? | Excel Worksheet Functions | |||
save multiple page setups in Excel | Excel Worksheet Functions | |||
How to print multiple worksheets in one workbook on the same page. | Excel Discussion (Misc queries) |