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?
Brandon GarnettAsked:
Who is Participating?
Brian PringleConnect With a Mentor Systems 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.
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?
Paul SauvéConnect With a Mentor 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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.