[2007] Multi-tab printing printer tray issues

I have an issue with printing selected sheets in a workbook. If a specify a 
paper source like tray 1 at the printer settings dialog the first selected 
sheet is printed to that tray, all other sheets are printed to the default 
paper source tray

Any suggestions?

Kind regards,
Peter 

0
peter4518 (1)
7/20/2007 8:24:13 AM
excel 39879 articles. 2 followers. Follow

1 Replies
385 Views

Similar Articles

[PageSpeed] 6

If you select multiple worksheets and open the page setup you can set the 
headers and pages numbers for all of the selected sheets.

However, when doing the above if you also select the printer setup and 
select the paper source, it is only set for the active sheet (that is the 
visible sheet). You can establish this by clicking on sheet 1 first and then 
hold the Ctrl to select the other sheets and set the paper source and then 
click on another sheet first before holding Ctrl to select the remaining 
sheets and go into the printer setup and it will not be changed.

To overcome the problem, select all the sheets for the page setup and 
complete the headers, footers and page numbers etc and then select the sheets 
individually ans set the paper source.

Regards,

OssieMac


"Peter" wrote:

> I have an issue with printing selected sheets in a workbook. If a specify a 
> paper source like tray 1 at the printer settings dialog the first selected 
> sheet is printed to that tray, all other sheets are printed to the default 
> paper source tray
> 
> Any suggestions?
> 
> Kind regards,
> Peter 
> 
0
OssieMac (238)
7/21/2007 4:30:01 AM
Reply:

Similar Artilces:

Class Pointer Issues
Hi everyone, Just a quick question. I'm making two different classes, but I'd like each to contain a pointer to the other type of class. I have a parent class which has pointers to many child classes, but each child class ideally would have a pointer back to the same parent class. When I attempt to compile the code I get an error: C2460: 'Cchild::Cparent' : uses 'Cchild', which is being defined I can understand that there is a circular problem but is this kind of idea possible, I'm sure you can do it in languages like Java. I'm only trying to pass pointer...

Change 2007 excel Autofilter back to 2003?
Does anyone know if there is a way to change excel's 2007 autofilter functionality back to like excel 2003 autoflilter use to work? I need to quickly bring up like values and compare other columns based upon the filtered values and the extra clicking of the check boxes is driving me nuts! If it helps any (and if you haven't thought about it yet), you can click the "(Select All)" entry twice to remove your current selections. -- Rick (MVP - Excel) "jonnybrovo815" <jonnybrovo815@discussions.microsoft.com> wrote in message news:36837406-1...

compare and merge documents in 2007
How do you compare 2 excel documents with track changes and merge them together after accepting the changes in Excel 2007? ...

How do I print a text file ?
Hi, I am new to the group and wonder if any of you could offer any advice. I am trying to print a text file directly from my visual c++ application to the default printer without displaying the print dialog What is the best way of doing this ? If it is not possible to print directly from a text file, what commands to I use in between CDC::StartPage () To print the following Hello, my name is Joe Bloggs How are you I hope you can help with this problem etc..... CDC::EndPage () Thanks in advance Paul Paul, More info on printing than you can comfortably shake a stick at: http://www....

Picture issue in Outlook
I've been having a picture issue in Outlook 2003 (NOT Outlook Express) that just started recently. I compose an E-Mail in outlook and it has a picture in it. I send the message. Now I go to look at the message in the "sent messages" folder and the picture isn't showing up; I get an empty white box with the red "X" in the upper left corner. But get this: If I click "Forward", THE PICTURE SHOWS UP IN THE MESSAGE I AM FORWARDING. So, clearly, the picture never left, it is simply not being displayed. ***I have all security image filt...

Page SetUp Print Problems
A friend has a spreadsheet that is giving him some problems. We go to Page Break Preview and the sheet is 2 pages wide. My friend wanted to make 1 page wide so we dragged the blue line to the right to make it one page. Excel, instead of doing that, made it 20 or more pages. We went to the Page Setup and noticed that Excel had changed the scaling down to 10%. We wanted it to be 1 page wide by 6 pages long so we put that info in but Excel did not accept it. We thought maybe something was wrong with the sheet itself so we selected all the cells and cut/paste them into a new sheet - but it s...

can I print selected cells only within a worksheet
I have designed a simple template using text only for a unique advice note. I want to be able to add variable information within this template but need only for the variable information to print onto a pre-printed advice note. I do not want to hide the template as I need to see exactly where to insert the variables but I do not want it to print. Anyone help? Thanks. Maybe you can use this ? http://www.rondebruin.nl/print.htm#Hide -- Regards Ron de Bruin http://www.rondebruin.nl "martin hanley" <martin hanley@discussions.microsoft.com> wrote in message news:AA062677-3...

Office 2010 setup issue
I am trying to install Office 2010 Beta. I previously had the Office 2010 Technical Preview installed. Setup required uninstalling the TP version which I did. When I tried installing both the 32 bit and 64 bit version of the Beta I recieved an Inetrnal Error. Now I can not even install the TP version. Any halp would be appreciated. -- Thanks I have a similar issue. When I install Office Professional Plus 2010 Beta,got an error message: Could not write value DisableExceptionChainValid ation to key \SOFTWARE\Microsoft\Windows NT\CurrentVersion\Image File Exceptin O...

record and print amounts in multiple boxes on 1099 forms
We have had several clients that have been very disappointed to learn that they can only do 1 amount box per 1099. For instance, they might need an amount for rents and one for non-employee compensation. I think it would need to be settable at time of transaction entry. One of our clients said they could do that in Quickbooks and was very surprised to learn that GP won't do it. -- BrianB ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in th...

Importing large tab-delimited text files?
I deal with very large data sets that are in tab-delimited .txt format. Many times, there are more than 256 columns of data. The Microsoft Knowledge Base had an article titled "Sample Macro to Import Data with More Than 256 Fields or Columns". This could do the trick for me if I could modify the macro to accomodate tab-delimited formats. Q1: Could anyone tell me how to modify the macro described above for tab-delimited .txt files? Q2: Does anyone know of a bulk file conversion utility that would change a tab-delimited text file to a CSV format? Thanks a bunch, Mark R-S Ma...

exchange 2007 reconnect
Hello UserA wanted UsersB mailbox. diabled both exchange mailbox and then reconnect userB to userA. UsersA is prompted for userB AD login info. the only way around this was to give userA sendas and full rights to the userB mailfile. Is there another way to fix it. ? what will happen when the AD account for userB is deleted for AD? ...

Problem sending mail in office 2007 and windows7
Hi, I have a word template which in autonew makes a mail merge and sends e-mail. This have worked fine but now one of my customers have updated to windows7 and office 2007 and suddenly no mail is sent. I have other customers running XP and office 2007 were it works fine. But for this client the question from outlook is raised asking if its OK to send mail from an other application but no mail is sent. The code: Sub Autonew() Dim SQL_sats As String Registry_Path = "HKEY_CURRENT_USER\Software\The company\Directories" Registry_Key = "CustDocs" Fo...

Printing the contacts in Exchange OWA 2000 or 2003
Is there any way to cleanly print out all the contacts in OWA Exchange 2000 or 2003? You can print a mailbox's contacts from Outlook. As far as contact objects in the domain/enterprise, you'll probably need to script somethign to extract the data adn then you could format it with Word. -- -- Brian Desmond Windows Server MVP desmondb@payton.cps.k12.il.us Http://www.briandesmond.com "Srfrdrew" <Srfrdrew@discussions.microsoft.com> wrote in message news:07829507-865A-4F36-89B9-163D5034208E@microsoft.com... > Is there any way to cleanly print out all the contact...

ODBC issues
My client's hard drive crashed over the weekend. They installed the new hard drive, they had been using MSDE but took the opportunity to install SQL 2005 Express. We then installed GP. At first the server was named "accounting." we couldn't get the odbc to work and renamed the computer (and the name changed for the SQL server) to "Accounting" as a workgroup. The first name had a period at the end of the name. We got the odbc to work on the server and GP works fine there, but we can't get the odbc to work on the client machines. We tried all three r...

How would you print a list of all the email addresses?
Exchange 2003 on AD 2003 IBM server. Need to print out a list of all user email addresses. How is this done? Probably select the user container and choose columns from the view menu and pick email address. Then choose export list under the actions menu. -- regards, Michael Abbaticchio MVP for Microsoft Exchange Server http://mvps.org/exchange "aspirin" <aspirin2004@yahoo.com> wrote in message news:040701c47a77$e697a010$a601280a@phx.gbl... > Exchange 2003 on AD 2003 IBM server. Need to print out a > list of all user email addresses. How is this done? Thank y...

print column labels with one row of data at a time.
I am a teacher. I have created my gradebook in excel. (I don't have access). I have 7 worksheets (one for each class that I teach). The worksheets are not exactly the same. I would like to be able to print out the top two rows (column labels) with each students data (row). This way the student can see row 1 (name of assignment), row 2 (points), their row (their personal data for each assignment). Any help?? Go to File > Page Setup > Sheet Then in the "Rows to repeat at top" highlight the label headings row(s). HTH -- _______________________ Naz, London...

Printing radio buttons
When I print a sheet with radio buttons they display with shadows around them. Is it possible to change their properties so that they simply print the circular outlines of the buttons instead of the boxed shadows? ...

Microsoft Dynamics CRM 3.0 Implementation in 2007
http://microsoft-crm-3.blogspot.com/ ...

Contact field in outlook 2007 new task page
Hi I had office 2003 and in the outlook new task menu, i used to fill in details as per my requirement. There was a field named contacts at the bottom of the page, where in i used to give some reference number and save. Once the task is saved it used to appear on the task menu with all other tasks. I had renamed the contacts column as ref no..column. Now I had installed office 2007. There is no filed appearing as contacts as it used to appear in 2003. Hence Im not able to fill my ref no in that field. It may be noted that Im not able to get the required field in the contacts menu avail...

Copy/Paste with Hidden Rows/Columns Excel 2007
I am working with rather large & detailed spreadsheets. I have hidden rows and columns with supporting details that feed into the viewable results (formulas). I need to take the “zipped up” data and copy/paste to a new worksheet. When I paste the data, it appears with all of the hidden columns and rows visible one again. Is there any way to paste the zipped up data without the reappearance of the previously hidden rows and columns? Can you paste a link without all of the hidden data reappearing? Select range to copy which includes hidden rows and columns. F5>Special...

access 2007 08-25-07
How do you remove the listings of databases that show under "Open Recent Datbases", on the opening screen? The files no longer exist. You can try, if your permissions are adequate, editing the registry and removing the entries. Try the following key: HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Settings\MRU -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Alan" <almkay@comcast.net> wrote in message news:YJadnbrdTMMXG03bnZ2dnUVZ_hisnZ2d@comcast.com... > How do you remove the listings of da...

Internet Explorer Favorites List In Outlook 2007
Does anyone know if it's possible to get your IE favorites list in Outlook 2k7? I can get every other web browsing command to show up in the toolbar except the favorites.. I can get "Add to Favorites" and "Organize Favorites" but the head of my organization wants the favorites list dropdown in there for browsing w/in Outlook. I could do it on Office 2k and 2k2. Thanks! "Howard" <heckmanenator@gmail.com> wrote in message news:efb4f45c-d4c9-4883-8d16-555d2ec7b67a@f63g2000hsf.googlegroups.com... > Does anyone know if it's possible to get your IE fa...

Callouts in PowerPoint 2007
in previous versions you used to be able to fix the pointer and move the text box relative.. This capability has appears to have diasappeared in version 2007.. Am I alone in finding the lack of this very useful feature a backward step or am I missin something? "Martin S Williams" <Martin S Williams @discussions.microsoft.com> wrote in message news:BF41DE66-B8AF-4C9D-9E33-6B7BE551D64F@microsoft.com... > in previous versions you used to be able to fix the pointer and move the > text > box relative.. This capability has appears to have diasappeared in...

Office 2010 hase corrupted Office 2007
Didn't like Office 2010 so uninstalled them but now getting error that MSO2007 hasn't been installed. I have a Windows Vista Ultimate, but I wasn't able to find installation for office from my dvd. How do I install them from my vista ultimate dvd? You require an Office cd in order to install it, Office is not on the Vista dvd "Michal" <Michal@discussions.microsoft.com> wrote in message news:D7E5FF59-1E89-4B8A-93C2-BFFCC0BA1DBA@microsoft.com... > Didn't like Office 2010 so uninstalled them but now getting error that > MSO2007 hasn't ...

crm accounts fail to sync with outlook 2007
Outlook when syncing with CRM 3.0 completes stage 1 OK of sync and then takes all contacts away from Outlook trying to sync and then only returns 91 of 1650 accounts. We have 2 other laptops, 1 excatly the same and sync's fine. The other is same brand lower spec model and is also failing. We have checked local data>and all fields are the same, any suggestions as this is really frustrating as our account contacts sync via active sync with our PPC , so we currently have no 91/1650 contacts on our phone.? thanks CD On Aug 7, 8:54 am, Dewy <D...@discussions.microsoft.com> wrote...