ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing (https://www.excelbanter.com/excel-discussion-misc-queries/44220-printing.html)

Al

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

Vincnet.

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?


Dave Peterson

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

Dodo

"?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)


All times are GMT +1. The time now is 10:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com