ExcelBanter - how to disable print button in preview

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - how to disable print button in preview (https://www.excelbanter.com/excel-programming/441910-how-disable-print-button-preview.html)

lABUDDY

how to disable print button in preview

hOW DO i DISABLE PRINT BUTTON IN PRINTVIEW

Brian

how to disable print button in preview

Add the following to your workbook code. Note that if the user has macro's
disabled it will not prevent it.

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

"lABUDDY" wrote:

hOW DO i DISABLE PRINT BUTTON IN PRINTVIEW

All times are GMT +1. The time now is 03:47 PM.