Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1351
  • Last Modified:

Disable printing and editing in an excel file

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
Brandon Garnett
Asked:
Brandon Garnett
2 Solutions
 
Brian PringleSystems Analyst II, SCM, ERPCommented:
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
 
Brandon GarnettAuthor Commented:
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
 
Paul SauvéRetiredCommented:
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

Who's Defending Your Organization from Threats?

Protecting against advanced threats requires an IT dream team – a well-oiled machine of people and solutions working together to defend your organization. Download our resource kit today to learn more about the tools you need to build you IT Dream Team!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now