Solved

Disable printing and editing in an excel file

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Disable Security Alert  popup in Winforms  embedded webbrowser. 1 57
Application Crash 2 25
Infrastructure development vs software development 3 60
WAN Link comparsion 3 28
One of the biggest threats facing all high-value targets are APT's.  These threats include sophisticated tactics that "often starts with mapping human organization and collecting intelligence on employees, who are nowadays a weaker link than network…
Data breaches are on the rise, and companies are preparing by boosting their cybersecurity budgets. According to the Cybersecurity Market Report (http://www.cybersecurityventures.com/cybersecurity-market-report), worldwide spending on cybersecurity …
This video Micro Tutorial is the second 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 a…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

839 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