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)

Related posts:

Excel:Print headers on every page

Toggle a macro on/off using a button

Excel vba: Save invoice data

Excel:Print consecutive pagenumbers from several sheets

Excel vba: Populate listbox with unique invoice numbers