How to: Print Worksheets
Applies to |
|---|
The information in this topic applies only to the specified Visual Studio Tools for Office projects and versions of Microsoft Office. Project type
Microsoft Office version
For more information, see Features Available by Application and Project Type. |
You can print any worksheet in a workbook.
Printing a Worksheet in a Document-Level Customization
To print a worksheet
Call the PrintOut method of Sheet1, request two copies, and preview the document before printing.
Globals.Sheet1.PrintOut(From:=1, To:=1, Copies:=2, Preview:=True)Globals.Sheet1.PrintOut(1, 1, 2, true, missing, missing, missing, missing);
The PrintPreview method enables you to display the specified object in the Print Preview window. The following code assumes you have a Worksheet host item named Sheet1.
To preview a page before printing
Call the PrintPreview method of the worksheet.
Globals.Sheet1.PrintPreview()Globals.Sheet1.PrintPreview(missing);
Printing a Worksheet in an Application-Level Add-In
To print a worksheet
Call the _WorksheetPrintOut(Object, Object, Object, Object, Object, Object, Object, Object) method of the active worksheet, request two copies, and preview the document before printing.
CType(Application.ActiveSheet, Excel.Worksheet).PrintOut _ (From:=1, To:=1, Copies:=2, Preview:=True)((Excel.Worksheet)Application.ActiveSheet).PrintOut (1, 1, 2, true, missing, missing, missing, missing);
The _WorksheetPrintPreview(Object) method enables you to display the specified object in the Print Preview window.
To preview a page before printing
Call the _WorksheetPrintPreview(Object) method of the active worksheet.
CType(Application.ActiveSheet, Excel.Worksheet).PrintPreview()((Excel.Worksheet)Application.ActiveSheet).PrintPreview(missing);
See Also
Tasks
How to: Check Spelling in Worksheets
How to: Send Workbooks by E-Mail Programmatically
Concepts
Global Access to Objects in Visual Studio Tools for Office Projects
The Variable missing and Optional Parameters in Office Solutions
Change History
Date |
History |
Reason |
|---|---|---|
July 2008 |
Added a code example that can be used in an application-level add-in. |
Customer feedback. |