do not allow printing a .xls

  • Thread starter Emanuel Violante
  • Start date
E

Emanuel Violante

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???
 
D

Doug Kanter

Emanuel Violante said:
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???
Click to expand...

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.
 
O

Otto Moehrbach

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
 
Top