Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe Joe is offline
external usenet poster
 
Posts: 476
Default How to change the printer paper source for all worksheets in a wrk

So here is my dilemna, I have a user who has an Excel workbook (Excel 2007)
which contains 14 worksheets. When he attempts to print this workbook, he
implicitely tells the printer driver to use the Manual Paper Feed as the
paper source for the entire workbook in his Dell MFP 3115cn printer, the
printer he is connected to. However, two of the workbook's worksheets refuse
to adhere to this setting (when you go to the page's setup for these
worksheets, the printer's paper source, in the printing preferences section,
is still listed as auto instead of MPF). This behavior occurs irrespective
of the printer used, in other words, the same occurs when attempting to print
to another printer. All worksheet pages are the same size (legal) and have
the same layout (landscape). So my question is, is there a way to force all
worksheets in this workbook to use the manual paper feed tray without having
to change this setting manually on each of the offending worksheets?
Apparently, this document will have a ton of revisions each week (roughly 10
to 20) and doing this manually is just not feasible for our chairman.

Your assistance with this will be greatly appreciated!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default How to change the printer paper source for all worksheets ina wrk

Do Select All Sheets first. (r-click one of the tabs)

Joe wrote:

So here is my dilemna, I have a user who has an Excel workbook (Excel 2007)
which contains 14 worksheets. When he attempts to print this workbook, he
implicitely tells the printer driver to use the Manual Paper Feed as the
paper source for the entire workbook in his Dell MFP 3115cn printer, the
printer he is connected to. However, two of the workbook's worksheets refuse
to adhere to this setting (when you go to the page's setup for these
worksheets, the printer's paper source, in the printing preferences section,
is still listed as auto instead of MPF). This behavior occurs irrespective
of the printer used, in other words, the same occurs when attempting to print
to another printer. All worksheet pages are the same size (legal) and have
the same layout (landscape). So my question is, is there a way to force all
worksheets in this workbook to use the manual paper feed tray without having
to change this setting manually on each of the offending worksheets?
Apparently, this document will have a ton of revisions each week (roughly 10
to 20) and doing this manually is just not feasible for our chairman.

Your assistance with this will be greatly appreciated!


  #3   Report Post  
Posted to microsoft.public.excel.misc
Joe Joe is offline
external usenet poster
 
Posts: 476
Default How to change the printer paper source for all worksheets in a

I tried that but it did not work.

"Bob I" wrote:

Do Select All Sheets first. (r-click one of the tabs)

Joe wrote:

So here is my dilemna, I have a user who has an Excel workbook (Excel 2007)
which contains 14 worksheets. When he attempts to print this workbook, he
implicitely tells the printer driver to use the Manual Paper Feed as the
paper source for the entire workbook in his Dell MFP 3115cn printer, the
printer he is connected to. However, two of the workbook's worksheets refuse
to adhere to this setting (when you go to the page's setup for these
worksheets, the printer's paper source, in the printing preferences section,
is still listed as auto instead of MPF). This behavior occurs irrespective
of the printer used, in other words, the same occurs when attempting to print
to another printer. All worksheet pages are the same size (legal) and have
the same layout (landscape). So my question is, is there a way to force all
worksheets in this workbook to use the manual paper feed tray without having
to change this setting manually on each of the offending worksheets?
Apparently, this document will have a ton of revisions each week (roughly 10
to 20) and doing this manually is just not feasible for our chairman.

Your assistance with this will be greatly appreciated!



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default How to change the printer paper source for all worksheets ina

Then for this try have the user set the printer default preferences in
the printer dialog before he opens the workbook.

Joe wrote:

I tried that but it did not work.

"Bob I" wrote:


Do Select All Sheets first. (r-click one of the tabs)

Joe wrote:


So here is my dilemna, I have a user who has an Excel workbook (Excel 2007)
which contains 14 worksheets. When he attempts to print this workbook, he
implicitely tells the printer driver to use the Manual Paper Feed as the
paper source for the entire workbook in his Dell MFP 3115cn printer, the
printer he is connected to. However, two of the workbook's worksheets refuse
to adhere to this setting (when you go to the page's setup for these
worksheets, the printer's paper source, in the printing preferences section,
is still listed as auto instead of MPF). This behavior occurs irrespective
of the printer used, in other words, the same occurs when attempting to print
to another printer. All worksheet pages are the same size (legal) and have
the same layout (landscape). So my question is, is there a way to force all
worksheets in this workbook to use the manual paper feed tray without having
to change this setting manually on each of the offending worksheets?
Apparently, this document will have a ton of revisions each week (roughly 10
to 20) and doing this manually is just not feasible for our chairman.

Your assistance with this will be greatly appreciated!




  #5   Report Post  
Posted to microsoft.public.excel.misc
Joe Joe is offline
external usenet poster
 
Posts: 476
Default How to change the printer paper source for all worksheets in a

Thanks, Bob I, but unbelievably, that does not work either.

"Bob I" wrote:

Then for this try have the user set the printer default preferences in
the printer dialog before he opens the workbook.

Joe wrote:

I tried that but it did not work.

"Bob I" wrote:


Do Select All Sheets first. (r-click one of the tabs)

Joe wrote:


So here is my dilemna, I have a user who has an Excel workbook (Excel 2007)
which contains 14 worksheets. When he attempts to print this workbook, he
implicitely tells the printer driver to use the Manual Paper Feed as the
paper source for the entire workbook in his Dell MFP 3115cn printer, the
printer he is connected to. However, two of the workbook's worksheets refuse
to adhere to this setting (when you go to the page's setup for these
worksheets, the printer's paper source, in the printing preferences section,
is still listed as auto instead of MPF). This behavior occurs irrespective
of the printer used, in other words, the same occurs when attempting to print
to another printer. All worksheet pages are the same size (legal) and have
the same layout (landscape). So my question is, is there a way to force all
worksheets in this workbook to use the manual paper feed tray without having
to change this setting manually on each of the offending worksheets?
Apparently, this document will have a ton of revisions each week (roughly 10
to 20) and doing this manually is just not feasible for our chairman.

Your assistance with this will be greatly appreciated!






  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default How to change the printer paper source for all worksheets ina

Can the settings be changed on those particular individual sheets? As in
they aren't protected or something?

Joe wrote:
Thanks, Bob I, but unbelievably, that does not work either.

"Bob I" wrote:


Then for this try have the user set the printer default preferences in
the printer dialog before he opens the workbook.

Joe wrote:


I tried that but it did not work.

"Bob I" wrote:



Do Select All Sheets first. (r-click one of the tabs)

Joe wrote:



So here is my dilemna, I have a user who has an Excel workbook (Excel 2007)
which contains 14 worksheets. When he attempts to print this workbook, he
implicitely tells the printer driver to use the Manual Paper Feed as the
paper source for the entire workbook in his Dell MFP 3115cn printer, the
printer he is connected to. However, two of the workbook's worksheets refuse
to adhere to this setting (when you go to the page's setup for these
worksheets, the printer's paper source, in the printing preferences section,
is still listed as auto instead of MPF). This behavior occurs irrespective
of the printer used, in other words, the same occurs when attempting to print
to another printer. All worksheet pages are the same size (legal) and have
the same layout (landscape). So my question is, is there a way to force all
worksheets in this workbook to use the manual paper feed tray without having
to change this setting manually on each of the offending worksheets?
Apparently, this document will have a ton of revisions each week (roughly 10
to 20) and doing this manually is just not feasible for our chairman.

Your assistance with this will be greatly appreciated!




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change external data source for multiple worksheets Pivot Tables[_2_] Excel Discussion (Misc queries) 4 July 27th 07 01:50 PM
Printer Multiple Worksheets with a particular Printer Setting PP[_2_] Excel Worksheet Functions 0 March 14th 07 02:02 PM
disable printer so worksheets CAN'T print accidentally??? Deb-in-Wisconsin Excel Discussion (Misc queries) 2 August 19th 06 07:13 PM
how do i elarge a printout of worksheet to cover printer paper [email protected] Excel Worksheet Functions 1 February 17th 06 12:16 AM
Printing all worksheets in a workbook using a duplex printer dott Excel Discussion (Misc queries) 1 November 30th 05 10:20 PM


All times are GMT +1. The time now is 12:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"