[Webinar] Streamline your web hosting managementRegister Today

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

Excel Protection

keep someone from saving or printing an Excel Workbook
0
GRDox
Asked:
GRDox
2 Solutions
 
William FulksSystems Analyst & WebmasterCommented:
There's no really good way to do this that someone with a little tech savvy can't work around by using screenshots, copy and paste, and a variety of other tools.

However, here's one option to prevent saving by making a simple macro:

http://www.excel-pratique.com/en/vba_tricks/preventing_a_file_from_being_saved.php

Here is another for disabling printing:

http://www.techrepublic.com/blog/microsoft-office/how-to-keep-others-from-printing-an-excel-worksheet/

Just keep in mind that anyone can turn on the "disable all macros" option and then none of this works.
0
 
Katie PierceCommented:
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

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