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 spreadsheetwithmacro is opened and resaved using XlsIO. Please note that this approach does not work when the user disables macros.
VB
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
End Sub
Did you find this information helpful?
Yes
No
We appreciate you taking the time to provide us with your feedback. Thank you for helping us make our articles even better!