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 clicked on.

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

https://youtu.be/LmsrpAHXddI

Create button

The button is found in the Form Controls group.

  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


(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. Click Module on the Insert menu
  3. Copy and paste "Sub Macro1" code below to code module
Sub Macro1()
  Application.Dialogs(xlDialogPrint).Show
End Sub

Download Excel file through email

Enter your email address to receive the workbook. Note, an email will actually be sent to you.
* You will also get a weekly newsletter, unsubscribe anytime!

You can find the other invoice tutorials here: Invoice category