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?
Recommended Excel Productivity Tools
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.