Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. If you want to prevent users from printing only particular sheets in your workbook, use this similar code instead
Sub workbook_BeforePrint(Cancel As Boolean)
   Select Case ActiveSheet.Name
          Case "Sheet1", "Sheet2"
          Cancel = True
          MsgBox "Sorry, you cannot print this sheet from this workbook", vbInformation
   End Select
End Sub