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.
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
Did you find this information helpful?
We appreciate you taking the time to provide us with your feedback. Thank you for helping us make our articles even better!