This post descibes how to create a print button on a excel sheet.

Create button (Form Control)

  1. Select sheet "Invoice"
  2. Click "Developer tab" on the ribbon
  3. Click "Insert" button
  4. Click Button (Form Control)
  5. Create button "Print Invoice"

Create macro

  1. Press Alt-F11 to open visual basic editor
  2. Click Module on the Insert menu
  3. Copy and paste "Sub Macro1" code below into module
Sub Macro1()
  Application.Dialogs(xlDialogPrint).Show
End Sub

Download excel sample file for this tutorial.

Print invoice.xls
(Excel 97-2003 Workbook *.xls)