Good morning DominicB

Thank you for replying.
Could you please supply me the code? I would like to try it out.

Will this code cause all the files open in excel cannot be printed?
Or can we set this code to run only in certain folders or external drive?

This is because I just want to prevent users from printing certain
confidential documents but not prevent them from doing other printings.

Regards.


"dominicb" wrote:


Good morning C Wayne

There is no standard way of doing this in Word or Excel, although you
could use VBA to disable the print menu item on Excel opening - which I
wouldn't advise to a novice - and restoring upon closing. I can supply
the code if you wish, but personally would advise against it.

As an aside, you can prevent users from printing from Acrobat, but it's
not that hard to circumvent to an experienced user.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=378459