Is it possible to protect an excel file from being printed by someone else?

I don't how to do that without a macro...
using macro, you can use the event of the workbook BeforePrint like this:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
End Sub


--
A+

V.


"Al" wrote:

Is it possible to protect an excel file from being printed by someone else?

Not really.

Even if you used Vincnet's suggestion, the user could disable macros (or even
events) and print.

Or even copy your data to a worksheet in another workbook and print from there.

Al wrote:

Is it possible to protect an excel file from being printed by someone else?

--

Dave Peterson

"?B?QWw=?=" wrote in
:

Is it possible to protect an excel file from being printed by someone
else?

Only by GT-DDS:

Go There and either Disable, Destroy or Steel their printer! ;-)))


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)