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.

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 pretty cool. Sometimes you need to take a screenshot of your worksheet and you can do […]

Comments(2) Filed in category: Excel, Print

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

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 […]

Comments(0) Filed in category: Excel, Macro, Print

Download excel sample file for this tutorial

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