Prevention of Printing

[Guest]

I would like to send an excel document to someone , it consists of
approximately 6 worksheets. Is there a way that I can prevent them from
printing it out once I have emailed it to them.
Any help would be appreciated.

 

[Guest]

Deejay,

Yes and no

You could add this macro to the workbook which prevents printing:-

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

The no bit comes in because no matter how clever we may think we are in
protecting our macros etc a reasonably determined user will crack that
protection very quickly with the help of a Google search.

In short the only way to stop them printing is don't send them the worksheet.

Mike