How can I prevent users from Printing a spreadsheet?

1 min read

Printing can be disabled by using a macro that cancels printing. A template spreadsheet with a macro is opened and resaved using XlsIO. Please note that this approach does not work when the user disables macros.

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

Did you find this information helpful?

Yes

Comments (0)

How can I prevent users from Printing a spreadsheet?

Access denied