Protection removed by copying

I have created a workbook with password protected sheets
and protected workbook but when I copy the sheets into a
new workbook the protection is removed. This kind of
defeats the objective of password protection doesn't it?.
How can I preserve the protection so that when a user
copies a sheet using either Edit/Copy or Ctrl+C the
protection is retained or it is possible to disable the
copy command?
David

Hi David

If you copy the whole sheet to a new workbook the protection remain
But not if you copy only the cells to a other workbook

How can I preserve the protection so that when a user
copies a sheet using either Edit/Copy or Ctrl+C the
protection is retained or it is possible to disable the
copy command?

You can do this with code but if the user disacle macro's it is not working
There is no Safe way to avoid this

--
Regards Ron de Bruin
http://www.rondebruin.nl


"David" wrote in message ...
I have created a workbook with password protected sheets
and protected workbook but when I copy the sheets into a
new workbook the protection is removed. This kind of
defeats the objective of password protection doesn't it?.
How can I preserve the protection so that when a user
copies a sheet using either Edit/Copy or Ctrl+C the
protection is retained or it is possible to disable the
copy command?
David

I don't think you can make the workbook secure. You can disable the Copy
Paste function, or any other function with VB code, but if the user chooses
to open with macros disabled they can do as they wish.
You can design a sheet so that its useless if macros are not enabled on
opening, as I myself have done, but its only effective with people that
don't have the desire or the knowledge to crack it. Anyone who does will do
so in no time at all.
Basically Excel protection isn't designed for security, more for preventing
mistakes like overwriting a formula with a value etc.
Regards,
"David" wrote in message
...
I have created a workbook with password protected sheets
and protected workbook but when I copy the sheets into a
new workbook the protection is removed. This kind of
defeats the objective of password protection doesn't it?.
How can I preserve the protection so that when a user
copies a sheet using either Edit/Copy or Ctrl+C the
protection is retained or it is possible to disable the
copy command?
David

Hi Ron
I am using Excel 2000 and protection does not remain when
I copy whole sheet to new workbook - seems no point in
using protection.
If I insert code that requies a password to open the
workbook can the user disable this?
David
-----Original Message-----
Hi David

If you copy the whole sheet to a new workbook the
protection remain
But not if you copy only the cells to a other workbook

How can I preserve the protection so that when a user
copies a sheet using either Edit/Copy or Ctrl+C the
protection is retained or it is possible to disable the
copy command?

You can do this with code but if the user disacle macro's
it is not working
There is no Safe way to avoid this

--
Regards Ron de Bruin
http://www.rondebruin.nl


"David" wrote in
message ...
I have created a workbook with password protected sheets
and protected workbook but when I copy the sheets into a
new workbook the protection is removed. This kind of
defeats the objective of password protection doesn't
it?.
How can I preserve the protection so that when a user
copies a sheet using either Edit/Copy or Ctrl+C the
protection is retained or it is possible to disable the
copy command?
David


.

You copied the sheets and the protection was removed????

I've never seen xl behave this way. What version are you using?

Copying the cells, then pasting avoids the protection completely--but if you
lock the cells and hide the formulas (under format|cells|protection), then when
you copy the locked cells from a protected worksheet, the paste will result in
values--not formulas.


And J.E. McGimpsey has code that'll unprotect your worksheet within moments:
http://www.mcgimpsey.com/excel/removepwords.html

I think that protecting a worksheet is used to lock cells to stop data entry
errors--It's not a security measure.


David wrote:

I have created a workbook with password protected sheets
and protected workbook but when I copy the sheets into a
new workbook the protection is removed. This kind of
defeats the objective of password protection doesn't it?.
How can I preserve the protection so that when a user
copies a sheet using either Edit/Copy or Ctrl+C the
protection is retained or it is possible to disable the
copy command?
David

--

Dave Peterson

Also.

How did you copy the sheets while the workbook was protected?

Gord Dibben Excel MVP

On Mon, 04 Oct 2004 18:10:56 -0500, Dave Peterson wrote:

You copied the sheets and the protection was removed????

I've never seen xl behave this way. What version are you using?

Copying the cells, then pasting avoids the protection completely--but if you
lock the cells and hide the formulas (under format|cells|protection), then when
you copy the locked cells from a protected worksheet, the paste will result in
values--not formulas.


And J.E. McGimpsey has code that'll unprotect your worksheet within moments:
http://www.mcgimpsey.com/excel/removepwords.html

I think that protecting a worksheet is used to lock cells to stop data entry
errors--It's not a security measure.


David wrote:

I have created a workbook with password protected sheets
and protected workbook but when I copy the sheets into a
new workbook the protection is removed. This kind of
defeats the objective of password protection doesn't it?.
How can I preserve the protection so that when a user
copies a sheet using either Edit/Copy or Ctrl+C the
protection is retained or it is possible to disable the
copy command?
David

Ctrl A
Ctrl C
Doesn't that work for you Gord?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"Gord Dibben" gorddibbATshawDOTca wrote in message
...
Also.

How did you copy the sheets while the workbook was protected?

Gord Dibben Excel MVP

On Mon, 04 Oct 2004 18:10:56 -0500, Dave Peterson wrote:

You copied the sheets and the protection was removed????

I've never seen xl behave this way. What version are you using?

Copying the cells, then pasting avoids the protection completely--but if
you
lock the cells and hide the formulas (under format|cells|protection), then
when
you copy the locked cells from a protected worksheet, the paste will result
in
values--not formulas.


And J.E. McGimpsey has code that'll unprotect your worksheet within
moments:
http://www.mcgimpsey.com/excel/removepwords.html

I think that protecting a worksheet is used to lock cells to stop data
entry
errors--It's not a security measure.


David wrote:

I have created a workbook with password protected sheets
and protected workbook but when I copy the sheets into a
new workbook the protection is removed. This kind of
defeats the objective of password protection doesn't it?.
How can I preserve the protection so that when a user
copies a sheet using either Edit/Copy or Ctrl+C the
protection is retained or it is possible to disable the
copy command?
David

I bet Gord was trying to find out if the worksheet was copied or the cells on
the worksheet were copied|pasted.

I've never seen xl lose the protection if the worksheet itself is copied.

Edit|move or copy sheet
(or rightclicking on the worksheet tab).

(I was less than clear in my post.)



RagDyer wrote:

Ctrl A
Ctrl C
Doesn't that work for you Gord?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"Gord Dibben" gorddibbATshawDOTca wrote in message
...
Also.

How did you copy the sheets while the workbook was protected?

Gord Dibben Excel MVP

On Mon, 04 Oct 2004 18:10:56 -0500, Dave Peterson wrote:

You copied the sheets and the protection was removed????

I've never seen xl behave this way. What version are you using?

Copying the cells, then pasting avoids the protection completely--but if
you
lock the cells and hide the formulas (under format|cells|protection), then
when
you copy the locked cells from a protected worksheet, the paste will result
in
values--not formulas.


And J.E. McGimpsey has code that'll unprotect your worksheet within
moments:
http://www.mcgimpsey.com/excel/removepwords.html

I think that protecting a worksheet is used to lock cells to stop data
entry
errors--It's not a security measure.


David wrote:

I have created a workbook with password protected sheets
and protected workbook but when I copy the sheets into a
new workbook the protection is removed. This kind of
defeats the objective of password protection doesn't it?.
How can I preserve the protection so that when a user
copies a sheet using either Edit/Copy or Ctrl+C the
protection is retained or it is possible to disable the
copy command?
David

--

Dave Peterson

Hi David,
You can prevent this from happening.
After protecting each sheet. Go to ToolsProtectionProtect
Workbook and type in a formula. Make sure "Structure" is checked.
You'll find the options disabled when you right click over the name
of the sheet.

Regards,

Anand.R.


--
anand132
------------------------------------------------------------------------
anand132's Profile: http://www.excelforum.com/member.php...o&userid=15012
View this thread: http://www.excelforum.com/showthread...hreadid=266264

Hi
I am using Excel 2000. If I do Ctrl+A then Ctrl+C, then
Ctrl+V into a new workbook, the protection is removed. It
does not seem to matter whether the whole sheet is locked
or certain cells.
I think you are right about protection being intended to
stop data entry -what I was wanting to do is to secure
the content so I can sell the file I have created and
protect my intellectual property to some degree.
David

-----Original Message-----
I bet Gord was trying to find out if the worksheet was
copied or the cells on
the worksheet were copied|pasted.

I've never seen xl lose the protection if the worksheet
itself is copied.

Edit|move or copy sheet
(or rightclicking on the worksheet tab).

(I was less than clear in my post.)



RagDyer wrote:

Ctrl A
Ctrl C
Doesn't that work for you Gord?
--

Regards,

RD
-------------------------------------------------------
-------------
Please keep all correspondence within the Group, so
all may benefit!
-------------------------------------------------------
------------

"Gord Dibben" gorddibbATshawDOTca wrote in message
...
Also.

How did you copy the sheets while the workbook was
protected?

Gord Dibben Excel MVP

On Mon, 04 Oct 2004 18:10:56 -0500, Dave Peterson
wrote:

You copied the sheets and the protection was
removed????

I've never seen xl behave this way. What version are
you using?

Copying the cells, then pasting avoids the protection
completely--but if
you
lock the cells and hide the formulas (under
format|cells|protection), then
when
you copy the locked cells from a protected worksheet,
the paste will result
in
values--not formulas.


And J.E. McGimpsey has code that'll unprotect your
worksheet within
moments:
http://www.mcgimpsey.com/excel/removepwords.html

I think that protecting a worksheet is used to lock
cells to stop data
entry
errors--It's not a security measure.


David wrote:

I have created a workbook with password protected
sheets
and protected workbook but when I copy the sheets
into a
new workbook the protection is removed. This kind of
defeats the objective of password protection
doesn't it?.
How can I preserve the protection so that when a
user
copies a sheet using either Edit/Copy or Ctrl+C the
protection is retained or it is possible to disable
the
copy command?
David

--

Dave Peterson

.