 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / August 2006How to Create a file in Excel that can't be copied or printed
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 >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?  SignatureDamon 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 > Cannot be done through Excel. > [quoted text clipped - 11 lines] >>be >>able to copy or print this file. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.