Solved

Disable printing and editing in an excel file

Posted on 2013-01-31
3
1,187 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 32

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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
downlod failures 6 68
EmsisoftAntiMalware is it trusted reliable 4 40
Video enhancement recommendation 7 76
Morphing two faces into one... 3 24
In this increasingly digital world, security hacks are no longer just a threat, but a reality. As we've witnessed with Target's big identity hack 2013, Heartbleed in 2015, and now Cloudbleed, companies and their leaders need to prepare for the unthi…
February 24, 2017 — On February 23, Travis Ormandy, a vulnerability researcher at Google, reported on Twitter (https://twitter.com/taviso/status/834900838837411840) that massive stores of data have been leaked by CloudFlare, a company that provide…
Sometimes we receive PDF files that are in the wrong orientation. They may be sideways or even upside down. This most commonly happens with scanned or faxed documents. It is possible to rotate the view of these PDFs with the free Adobe Reader produc…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

685 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