How to Create a file in Excel that can't be copied or printed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Cannot be done through Excel.

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


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

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

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.
 
Gord Dibben wrote...
Cannot be done through Excel.

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

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Create a file in Excel that can't be copied or printed 2
How can we convert OST to PDF file format? 1
Save data from Notebook: copying to the USB stick using Linux and the command line 0
How to best select from image and print full size? 1
Access Certificates in access 1
Excel VBA - Problem with Closing Print Preview 0
Excel Move or Copy Stopped Working? 0
Windows 7 Difference in "size on disc" between files and copied files - a problem? 3

Back
Top