VBA Code for Print Button in Excel (5 Examples)

If we can set a custom Print Button in our Excel worksheet then it can be very user-friendly and time-saving for printing sheets. By using VBA Macros, we can easily do it. So this article will provide you with 5 simple macros to use VBA code for the print button in Excel.

How to Use VBA Code for Print Button in Excel: 5 Examples

Let’s get introduced to our dataset first that represents some salesperson’s sales in different Regions.

1. Use VBA Code to Make Print Button for Print Dialog Box in Excel

First, we’ll create a Print Button and then will write codes for it.

Steps:

• Click as follows: Developer >> Insert >> Button Box.

Soon after, you will get a plus sign (+) in your cursor.

• Drag that cursor according to your desired button size and after a while, a dialog box named Assign Macro will open up.

• Give a name and press New.

A VBA window will appear.

• Then type the following codes in it-

Sub DialogBox()
Application.Dialogs(xlDialogPrint).Show
End Sub

• Now go back to your sheet.

The button is created.

• Right-click on the button and select Edit Text from the Context menu to change the button name.

• Later, just type the name and click your mouse anywhere outside of the Button.

Then just press the Button.

Then you will get the Print dialog box. If you want you can Print it now.

If you don’t have any Printer at this moment you can Save it as PDF.  for further use or to Print later.

• Now press OK.

• At this moment just give a name and press Save.

Here’s the printed PDF.

2. Use VBA Code to Make Print Button for Active Sheet

Here, we’ll use VBA Macros to print an Active Sheet.

Steps:

• Follow the first two-step from the first section to create the button and Assign a Macro.
• Write a Macro Name and press New.

Soon after, a VBA window will open up.

• Then write the following codes in it-

Sub ActiveSheet()
ActiveSheet.PrintOut
End Sub

• Later, go back to the

• Now just press the Button.

A dialog box named Save Print output As will open up.

• Give a name and press Save.

Then you will get the printed PDF.

You can easily change the printer if you need it.

• Click on File beside the Home

• Then select Print option and click on the drop-down to select a Printer.

3. Apply VBA Code to Create Print Button for Selected Sheets in Excel

If you want to Print specific selected sheets then it is also possible using VBA.

Steps:

• Follow the first two-step from the first section to create the button and assign a macro.
• Then write a Macro Name and press New.

Soon after, a VBA window will open up.

• Later, type the following codes in it-

Sub SelectedSheets()
ActiveWindow.SelectedSheets.PrintOut
End Sub

Then go back to your sheet.

• Now select sheets and press the Print Button. I selected two sheets.

• Give a name for the PDF and press Save.

The PDF file has two pages for the two sheets.

4. Embed Excel VBA to Create Print Button for Specific Sheet with Selected Range

Here, we’ll make a Print Button to print a selected range from a specific sheet.

Steps:

• Follow the first two-step from the first section to create the button and assign a macro.
• Write a Macro Name and press New.

Soon after, a VBA window will open up.

• Then write the following codes–

Sub SpecificSheetnRange()
With Sheets("SpecificSheet+Range")
   .PageSetup.PrintArea = "B2:D11"
   .PrintOut
 End With
End Sub

• Later, go back to your sheet.

• Now just press the Print Button.

• Set a name for the PDF and press Save.

It’s the printed specific sheet.

5. Embed Excel VBA to Create Print Button for Active Sheet with Selected Range

Also, you can select a range from the active sheet and can make a Print Button to print it using VBA.

Steps:

• Follow the first two-step from the first section to create the button and assign a macro.
• Later, write a Macro Name and press New.

Soon after, a VBA window will open up.

• In the VBA window, write the following codes–

Sub ActiveSheetnRange()
Range("B2:D11").PrintOut
End Sub

• Then go back to your sheet.

• Press the Print Button.

• Give a name and press Save.

Then you will get the printed range.

Read More: Excel VBA: Print Preview for Selected Range

Download Practice Workbook

You can download the free Excel template from here and practice on your own.

Conclusion

I hope the procedures described above will be good enough to use VBA code for the print button in Excel. Feel free to ask any question in the comment section and please give me feedback.

Related Articles

• How to Display Print Preview with Excel VBA
• Excel VBA Debug Print: How to Do It?
• Excel VBA: How to Set Print Area Dynamically
• How to Set Print Area to Selection Using VBA in Excel
• Excel VBA: Set Print Area for Multiple Ranges
• Excel VBA: Print Range of Cells
• Excel VBA to Display Print Preview for Multiple Sheets