Protection removed by copying

[David]

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

 

[Ron de Bruin]

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

 

[Alan]

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,

 

[Guest]

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


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" <[email protected]> wrote in

message news:[email protected]...

 

[Dave Peterson]

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.

 

[Gord Dibben]

Also.

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

Gord Dibben Excel MVP

 

[RagDyer]

<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

 

[Dave Peterson]

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.)

 

[anand132]

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

Regards,

Anand.R. :

 

[David]

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.)

<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

 

[David]

Sorry I forgot to say that the formulas are not copied so
in effect the sheet is not functional but the other
content is unprotected
David

-----Original Message-----
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.)

-

-------------

-

------------

 

[Ron de Bruin]

Hi David

If you use Ctrl-A to select and Ctrl-C to copy then you copy only cells
and not the worksheet.

If you copy the worksheet(right click on a sheet tab and use "Move and copy)
then you copy the whole sheet with the protection

 

[Gord Dibben]

If you copy the worksheet(right click on a sheet tab and use "Move and copy)

then you copy the whole sheet with the protection

If the workbook is not protected, yes.

David stated in original post that workbook protection was enabled.

Gord

 

[Gord Dibben]

Sure does, but that is not copying the sheet.

That is copying the cells.

Gord

 

[Ron de Bruin]

David stated in original post that workbook protection was enabled.

Thanks Gord

 

[Gord Dibben]

Correction to query.

If "Windows" and not "Structure" is selected when applying Workbook Protection
the sheet can copied.

Gord

 

[David]

Anand
I had the Workbook protected and you are right the Insert,
Delete, Rename, Move and Copy commands are all greyed out
but the Ctrl+C command still copies the sheet and removes
the protection. It does not however, copy the formula but
it was the content rather than the formula that I was
hoping to protect - any ideas? Can I disable the Ctrl+C
and Ctrl+V command?
David

 

[Dave Peterson]

You can try to disable the ctrl-c/ctrl-v shortcuts, but I'd bet anything you
devised would be macro based.

And if the user choses to disable macros, then your efforts will be wasted.

And as you saw in that link to J.E. McGimpsey's site, workbook and worksheet
protection isn't made for this kind of security.

 

[RagDyer]

You got me there, Gord.<g>
--

Regards,

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

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
Sure does, but that is not copying the sheet.

That is copying the cells.

Gord