Solved

Disable printing and editing in an excel file

Posted on 2013-01-31
3
1,130 Views
Last Modified: 2013-02-06
We would like to find a way that we can disable users from printing and editing an excel workbook.  Is there an easy way to do this in Excel 2010?
0
Comment
Question by:rcimasi
3 Comments
 
LVL 16

Accepted Solution

by:
Brian Pringle earned 250 total points
ID: 38840615
Editing is easy with the "Protest and Share workbook".  Printing is another problem.  You can setup rights, but it will only work within your organization.  

I find that converting them to password-protected PDF files with security configured is better.
0
 

Author Comment

by:rcimasi
ID: 38840639
Yea PDF's would be the way to go, but my management wants to figure out a way to do it from an excel document, would there be a macro to prevent printing and then hide the content unless macros are enabled?
0
 
LVL 31

Assisted Solution

by:Paul Sauvé
Paul Sauvé earned 250 total points
ID: 38841580
No editing is easy enough, but in reality, ANYONE who can view the document simply uses the Print Screen function if a hard copy is required.

You can then take a printed copy and scan using OCR to get the data back! You can even do this with 'non printing' web pages! I thought that this technique was widely known.
0

Featured Post

Network it in WD Red

There's an industry-leading WD Red drive for every compatible NAS system to help fulfill your data storage needs. With drives up to 8TB, WD Red offers a wide array of solutions for customers looking to build the biggest, best-performing NAS storage solution.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

All of the resources available today make learning a new digital media easier than ever-- if you know where to begin. This is a clear, simple guide to a few of the basic digital art mediums and how to begin learning them on your own.
In 2017, ransomware will become so virulent and widespread that if you aren’t a victim yourself, you will know someone who is.
Viewers will learn how to use the Hootsuite Dashboard.
This video Micro Tutorial is the first in a two-part series that shows how to create and use custom scanning profiles in Nuance's PaperPort 14.5 (http://www.experts-exchange.com/articles/17490/). But the ability to create custom scanning profiles al…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now