Articles in this section
Category / Section

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 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?
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment