How to disable copy of protected excel worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I protected one excel worksheet but it can still be copied to another new
workbook with content being able to be modified. How to disable this action?
 
I don't think you can.

Any attempt that I would try would rely on macros and macros can be disabled.
 
Hello, Dave!
You wrote on Thu, 14 Sep 2006 07:52:04 -0500:

DP> Any attempt that I would try would rely on macros and
DP> macros can be disabled.

DP> FinishMan wrote:
??>>
??>> I protected one excel worksheet but it can still be copied
??>> to another new workbook with content being able to be
??>> modified. How to disable this action?

It might depend some on what you want to do with the data. If
you copied the worksheet to *Word*, the information would be
visible but it would not be a spreadsheet. I could extract the
data but it would be a lot of work.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not
 
Or just open the workbook with macros disable, unprotect the worksheet and do
whatever you want with the workbook/worksheet.
 
Back
Top