Author: Oscar Cronquist Article last updated on January 08, 2019

This article describes how to create a button and place it on an Excel worksheet then assign a macro to that button allowing the user to print the worksheet when the button is press with left mouse button oned on.

Watch a video where I explain the steps to insert a print button

Create button

The button is found in the Form Controls group.

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

Create macro


(The macro shown in the image above is not used here in this article, it only demonstrates where to paste the code.)

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

Get the Excel file


Print-invoice.xls

You can find the other invoice tutorials here: Invoice category