Solved

Excel Protection

Posted on 2015-01-29
3
72 Views
Last Modified: 2015-02-11
keep someone from saving or printing an Excel Workbook
0
Comment
Question by:GRDox
3 Comments
 
LVL 14

Accepted Solution

by:
William Fulks earned 250 total points
ID: 40578194
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
 
LVL 7

Assisted Solution

by:Katie Pierce
Katie Pierce earned 250 total points
ID: 40587160
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Trying to populate a summary worksheet in excel from another worksheet 14 92
outlook 2016 orgnize ideas 2 92
Button in Excel 5 95
VBA MS Word "Table of Contents" extractor` 4 56
I recently resolved a client's Office 2013 installation problem and wanted to offer an observation that may help you with troubleshooting similar issues. The client ordered three Dell Optiplex system units with the Windows 7 downgrade option inst…
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

860 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