Advertisement

07.03.2008 at 07:18AM PDT, ID: 23536921
[x]
Attachment Details

Locking Excel to prevent users from copying data

Asked by OB1Canobie in Microsoft Excel Spreadsheet Software, Programming Languages, Visual Basic Programming

Tags: ,

I currently have a project that requires the use of Excel Workbooks to be sent to employees to work from.  Currently I am protecting the worksheets from being manipulated, however, the employees are copying the entire worksheet and creating an entire new Excel document...then they can do whatever they wish.  Does anyone know a way to prevent the user from copying data from a worksheet?  Thanks.Start Free Trial
[+][-]07.03.2008 at 07:29AM PDT, ID: 21925800

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 07:35AM PDT, ID: 21925856

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 07:35AM PDT, ID: 21925857

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 07:46AM PDT, ID: 21925965

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 07:57AM PDT, ID: 21926079

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 08:07AM PDT, ID: 21926169

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 09:11AM PDT, ID: 21926856

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 10:11AM PDT, ID: 21927344

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.03.2008 at 10:25AM PDT, ID: 21927456

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Excel Spreadsheet Software, Programming Languages, Visual Basic Programming
Tags: VBA, Internet Explorer 6.0
Sign Up Now!
Solution Provided By: byundt
Participating Experts: 4
Solution Grade: A
 
 
[+][-]07.03.2008 at 11:40AM PDT, ID: 21928057

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628