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

  • Document-level projects

  • Application-level projects

Microsoft Office version

  • Excel 2003

  • Excel 2007

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

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

Working with Worksheets

Worksheet Host Item

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.