I'm creating a read only file on a network drive but I don't want users to be
able to copy or print this file.

Cannot be done through Excel.

Get your administrator to deny permission to users for anything but reading the
file.


Gord Dibben MS Excel MVP

On Fri, 18 Aug 2006 07:17:42 -0700, enroh
wrote:

I'm creating a read only file on a network drive but I don't want users to be
able to copy or print this file.

Gord Dibben wrote...
Cannot be done through Excel.

Get your administrator to deny permission to users for anything but reading the
file.
....

File system read permission only prevents modifying/overwriting the
file. It won't even prevent saving the file with a different filename
or in a different drive/directory. It certainly won't prevent printing.

You can shut some things down. For example, add some code to the BeforePrint
and BeforeSave event.

But as others have said, you will not be able to completely lock this file
down. I wonder why you are so protective of this data?

--
Damon Longworth

2006 West Coast Excel / Access User Conference
October 25-27th, 2006
Marina del Rey Hotel
Marina del Rey, California USA
http://www.exceluserconference.com/WCEUC.html

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Cannot be done through Excel.

Get your administrator to deny permission to users for anything but
reading the
file.


Gord Dibben MS Excel MVP

On Fri, 18 Aug 2006 07:17:42 -0700, enroh

wrote:

I'm creating a read only file on a network drive but I don't want users to
be
able to copy or print this file.