I presume you're talking about Excel files? If so, probably the easiest way
is to intercept the Print action for the file and cancel it. To do this you
need to add workbook event code shown below. To put the code into a workbook
in the right place:
right-click on the Excel icon immediately to the left of the word File in
the menu bar and choose [View Code] from the popup list that appears. Copy
and paste in the code below. Then save the file and send via email.

To allow yourself to print it, again right-click on that icon and [View
Code] and just delete the code from the module.

If you want to keep anyone from being able to easily remove the code, you'll
need to password protect the VBA Project - if you need those instructions,
either use HELP in the VB Editor or ask here.

The code:


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


If you're speaking in generic terms regarding other types of documents
besides Excel files, probably best to get a copy of Adobe Acrobat which will
permit you to convert a file into a .pdf that you can set security on to
prevent (easy) printing. I said (easy) because there is always the
individual who, given enough time, resources and determination, will tear
down almost any wall.

"Felicia" wrote:

Is there any way when I send out my document via email to make it so the
recipients cant print the document?