Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change the printer paper source for all worksheets in a
Yes, they can be modified individually.
"Bob I" wrote: 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! |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change the printer paper source for all worksheets ina
Do they stay modified if you go to a different sheet, change print
settings and then look at the problem sheet again? Joe wrote: Yes, they can be modified individually. "Bob I" wrote: 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! |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change the printer paper source for all worksheets in a
Yes, it appears that the pages in question retain theses settings. However,
I just noticed that when I send this workbook to the printer to be printed, three separate jobs are sent to the printer's queue. My guess is that this may explain why these settings do not take for the entire workbook... "Bob I" wrote: Do they stay modified if you go to a different sheet, change print settings and then look at the problem sheet again? Joe wrote: Yes, they can be modified individually. "Bob I" wrote: 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! |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change the printer paper source for all worksheets ina
Interesting discovery. Are the two odd sheets the "extra" print jobs?
Maybe there is a macro involved on those 2 sheets? Joe wrote: Yes, it appears that the pages in question retain theses settings. However, I just noticed that when I send this workbook to the printer to be printed, three separate jobs are sent to the printer's queue. My guess is that this may explain why these settings do not take for the entire workbook... "Bob I" wrote: Do they stay modified if you go to a different sheet, change print settings and then look at the problem sheet again? Joe wrote: Yes, they can be modified individually. "Bob I" wrote: 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! |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change the printer paper source for all worksheets in a
Yes, they are. I'm confirming with the document's owner whether or not there
are any macros in the workbook but I do not get a warning message about macros when I open it so I don't think so. "Bob I" wrote: Interesting discovery. Are the two odd sheets the "extra" print jobs? Maybe there is a macro involved on those 2 sheets? Joe wrote: Yes, it appears that the pages in question retain theses settings. However, I just noticed that when I send this workbook to the printer to be printed, three separate jobs are sent to the printer's queue. My guess is that this may explain why these settings do not take for the entire workbook... "Bob I" wrote: Do they stay modified if you go to a different sheet, change print settings and then look at the problem sheet again? Joe wrote: Yes, they can be modified individually. "Bob I" wrote: 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! |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change the printer paper source for all worksheets in a
The document's creator claims that there are no macros in this workbook.
"Joe" wrote: Yes, they are. I'm confirming with the document's owner whether or not there are any macros in the workbook but I do not get a warning message about macros when I open it so I don't think so. "Bob I" wrote: Interesting discovery. Are the two odd sheets the "extra" print jobs? Maybe there is a macro involved on those 2 sheets? Joe wrote: Yes, it appears that the pages in question retain theses settings. However, I just noticed that when I send this workbook to the printer to be printed, three separate jobs are sent to the printer's queue. My guess is that this may explain why these settings do not take for the entire workbook... "Bob I" wrote: Do they stay modified if you go to a different sheet, change print settings and then look at the problem sheet again? Joe wrote: Yes, they can be modified individually. "Bob I" wrote: 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! |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change the printer paper source for all worksheets ina
Humm, I'm running out of guesses as to what is causing the issue then.
Perhaps someone else has an idea. Joe wrote: The document's creator claims that there are no macros in this workbook. "Joe" wrote: Yes, they are. I'm confirming with the document's owner whether or not there are any macros in the workbook but I do not get a warning message about macros when I open it so I don't think so. "Bob I" wrote: Interesting discovery. Are the two odd sheets the "extra" print jobs? Maybe there is a macro involved on those 2 sheets? Joe wrote: Yes, it appears that the pages in question retain theses settings. However, I just noticed that when I send this workbook to the printer to be printed, three separate jobs are sent to the printer's queue. My guess is that this may explain why these settings do not take for the entire workbook... "Bob I" wrote: Do they stay modified if you go to a different sheet, change print settings and then look at the problem sheet again? Joe wrote: Yes, they can be modified individually. "Bob I" wrote: 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! |
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change the printer paper source for all worksheets in a
It seems this workbook was "misconstructed". The document's creator provided
us with a version that prints normally but with no explanation as to why the original version was abnormal. Thanks for all your help, Bob I! "Bob I" wrote: Humm, I'm running out of guesses as to what is causing the issue then. Perhaps someone else has an idea. Joe wrote: The document's creator claims that there are no macros in this workbook. "Joe" wrote: Yes, they are. I'm confirming with the document's owner whether or not there are any macros in the workbook but I do not get a warning message about macros when I open it so I don't think so. "Bob I" wrote: Interesting discovery. Are the two odd sheets the "extra" print jobs? Maybe there is a macro involved on those 2 sheets? Joe wrote: Yes, it appears that the pages in question retain theses settings. However, I just noticed that when I send this workbook to the printer to be printed, three separate jobs are sent to the printer's queue. My guess is that this may explain why these settings do not take for the entire workbook... "Bob I" wrote: Do they stay modified if you go to a different sheet, change print settings and then look at the problem sheet again? Joe wrote: Yes, they can be modified individually. "Bob I" wrote: 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! |
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change the printer paper source for all worksheets ina
You're most welcome. That would be an interesting nut to puzzle out
someday when there was nothing to do. Joe wrote: It seems this workbook was "misconstructed". The document's creator provided us with a version that prints normally but with no explanation as to why the original version was abnormal. Thanks for all your help, Bob I! "Bob I" wrote: Humm, I'm running out of guesses as to what is causing the issue then. Perhaps someone else has an idea. Joe wrote: The document's creator claims that there are no macros in this workbook. "Joe" wrote: Yes, they are. I'm confirming with the document's owner whether or not there are any macros in the workbook but I do not get a warning message about macros when I open it so I don't think so. "Bob I" wrote: Interesting discovery. Are the two odd sheets the "extra" print jobs? Maybe there is a macro involved on those 2 sheets? Joe wrote: Yes, it appears that the pages in question retain theses settings. However, I just noticed that when I send this workbook to the printer to be printed, three separate jobs are sent to the printer's queue. My guess is that this may explain why these settings do not take for the entire workbook... "Bob I" wrote: Do they stay modified if you go to a different sheet, change print settings and then look at the problem sheet again? Joe wrote: Yes, they can be modified individually. "Bob I" wrote: 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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change external data source for multiple worksheets | Excel Discussion (Misc queries) | |||
Printer Multiple Worksheets with a particular Printer Setting | Excel Worksheet Functions | |||
disable printer so worksheets CAN'T print accidentally??? | Excel Discussion (Misc queries) | |||
how do i elarge a printout of worksheet to cover printer paper | Excel Worksheet Functions | |||
Printing all worksheets in a workbook using a duplex printer | Excel Discussion (Misc queries) |