- If you are printing to a file, only some of the sheets are printed to the file; remaining sheets are printed to your printer.
- If you are printing to a file, you may be prompted to enter the name of the output file multiple times.
As a result, more than one output file is generated. Each file contains part of the complete printout.
- If you are using a Microsoft Visual Basic for Applications macro to print the sheets, the macro may fail because there are multiple requests for names for the output files.
- If you are printing to a network printer that is heavily used, your print jobs may be mixed in with other users' print jobs.
NOTE: This behavior does not occur when you print the same worksheets in earlier versions of Microsoft Excel.
Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. The following Visual Basic macro ensures that all worksheets in a workbook use the same print quality settings:
For Each xSheet In ActiveWorkbook.Sheets
xSheet.PageSetup.PrintQuality = 600
After you run this macro, all of the worksheets use the same print quality setting, and the behavior no longer occurs.
- Create a new workbook that contains three worksheets, for example, Sheet1, Sheet2, and Sheet3.
- In each worksheet, enter the following values:
Sheet1:A1: Sheet1 - 300 DPISheet2:A1: Sheet2 - 600 DPISheet3:A1: Sheet3 - 300 DPI
- Click Sheet1. On the File menu, click Page Setup, and then click the Page tab. In the Print Quality list, click "300 dpi" and click OK.
- Repeat step 3 for Sheet2 and Sheet3, setting the Print Quality to "600 dpi" and "300 dpi" respectively.
Note that each worksheet uses a different print quality than the worksheet that precedes it.
- Right-click the sheet tab for Sheet1. On the shortcut menu, click Select All Sheets.
- On the File menu, click Print. In the Printer section of the Print dialog box, click to select the Print To File check box. Then, click OK.
- If you are using a printer driver that is connected to the FILE: port, the Print To File dialog box appears three times.
- If you are using a printer driver that is connected to the LPT1:, LPT2:, or any other port that is connected to a printer, the Print To File dialog box appears only once for Sheet1. The other worksheets are printed to the printer.
- If you use a Visual Basic macro to print the worksheets, the Print To File dialog box may appear more than once. If you are using the SendKeys method to send the name of the output file to the Print To File dialog box, the macro may fail if the dialog box appears more than once.
Id. de artículo: 168563 - Última revisión: 08/17/2009 - Revisión: 1