ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   do not allow printing a .xls (https://www.excelbanter.com/excel-discussion-misc-queries/75772-do-not-allow-printing-xls.html)

Emanuel Violante

do not allow printing a .xls
 
Hi,

I have a .xls file and i would like users to view and edit the file, but i
don't want it to be printed, is there any way to do it???
--
Thanks,

Emanuel Violante Galeano

Doug Kanter

do not allow printing a .xls
 

"Emanuel Violante" wrote in
message ...
Hi,

I have a .xls file and i would like users to view and edit the file, but i
don't want it to be printed, is there any way to do it???
--
Thanks,

Emanuel Violante Galeano


I don't know, but you'd better make sure they can't use the email function
on the File menu. That would easily bypass your printing ban.



Otto Moehrbach

do not allow printing a .xls
 
Yes, there is a way to do that. But as Doug said, they can get the
information in your file other ways.
You can use a Workbook_BeforePrint macro that will stop all printing and can
display a message box to the user saying whatever you want. However, if he
elects to open the file with macros disabled, this will be for naught and he
can print anything he wants. Post back if you want to go the macro route.
HTH Otto
"Emanuel Violante" wrote in
message ...
Hi,

I have a .xls file and i would like users to view and edit the file, but i
don't want it to be printed, is there any way to do it???
--
Thanks,

Emanuel Violante Galeano





All times are GMT +1. The time now is 05:13 AM.

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