Author: Oscar Cronquist Article last updated on January 02, 2018

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

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"

Recommended article:

Print screen the entire worksheet

I recently discovered something quite useful. Allow me to explain, sometimes you need to take a screenshot of your worksheet […]

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()
End Sub

Remove print preview lines (Page Breaks)

Have you ever wondered how these lines got there on a worksheet? They show where pages will break, in other […]

Download excel sample file for this tutorial

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