Excel: Suppress Print option

[Rob Mack]

Does anyone know if it is possible to actually disable the Print option, like you can for PDF files? We convert commercially sensitive docs to PDF at present for internal use, but you loose too much functionality. Cheers. Rob

 

[Tazguy37]

Welcome to MrExcel Board!

You could put this in the ThisWorkbook module of the workbook:

Private Sub Workbook_BeforePrint(Cancel As Boolean) 
     Cancel = True 
End Sub

• How to use the above code:
  
  Press Alt-F11 to open the VBE.
  Press Control-R to open the Project Explorer.
  Click "Microsoft Excel Objects" for the file you're working on.
  Double-click the sheet module where you need this to work.
  Double-click the ThisWorkbook module.
  
  Paste the above code into the right window.
  Press Alt-Q to close the VBE and return to Excel

Hope that helps!