E
enroh
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.
able to copy or print this file.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
Cannot be done through Excel.
Get your administrator to deny permission to users for anything but reading the
file.
Gord Dibben MS Excel MVP
Get your administrator to deny permission to users for anything but reading the
file.
Gord Dibben MS Excel MVP
H
Harlan Grove
Gord Dibben wrote...
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.
....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.
D
Damon Longworth
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
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