How to exclude a specific worksheet when printing workbook?

If you have a workbook which contains multiple worksheets needed to be printed but exclude a specific one, is there any quick and easy method for us to print all sheets except one in Excel?

Exclude a specific worksheet when printing workbook with VBA code

---

Exclude a specific worksheet when printing workbook with VBA code

To print the whole workbook except one specific worksheet, the following VBA code can help you.

1. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and paste the following code in the Module Window.

VBA code: Exclude a specific worksheet when printing workbook:

Private Sub Printexclude()
'Updateby Extendoffcie 20161206
    Dim ws As Worksheet
    Dim strShName As String
    On Error Resume Next
    strShName = Application.InputBox("Enter the sheet name you want to exclude:", _
    "Kutools For Excel", , , , , , 2)
    Application.ScreenUpdating = False
    For Each ws In ThisWorkbook.Worksheets
        If ((ws.Visible = xlSheetVisible) And _
         (ws.Name <> strShName)) Then ws.PrintOut
    Next ws
    Application.ScreenUpdating = True
End Sub

3. And then press F5 key to run this code, and a prompt box is popped out to remind you enter the sheet name which you want to exclude when printing the workbook, see screenshot:

4. Then click OK button, and other worksheets will be printed at once exclude the specific sheet as you need.

---