Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Warwick, Warwickshire, England
    Thanked 0 Times in 0 Posts

    Protect and copy (2000)

    I have protected a number of cells of a sheet in a workbook - protection works correctly.

    If I attempt to copy the sheet which is protected to another sheet in the workbook, protection is maintained.

    If I create a new sheet in the workbook and COPY the entire contents of the protected sheet to this sheet, protection is not applied to the new sheet.

    A feature? I'm sure this wasn't the case in Excel 97.

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Thanked 1 Time in 1 Post

    Re: Protect and copy (2000)

    It's designed to work this way. If you want to prevent formulas being copied then you can select the hidden option on the protection tab within Format>Cells dialog. With the hidden option selected only the values of the cells will be copied.
    Excel worksheet passwords are very easy to crack so this is only limited protection. The best way to look at Excel protection is it being a method to prevent accidental deletion of formulas/data.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Pittsburgh, Pennsylvania, USA
    Thanked 342 Times in 335 Posts

    Re: Protect and copy (2000)

    <hr>I'm sure this wasn't the case in Excel 97.<hr>
    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17>I don't know what version of XL97 you did this with, but I am really sure what you describe is exactly how XL97 handles protection, since I just confirmed it, with my version of XL97 (which I still am using). <img src=/S/grin.gif border=0 alt=grin width=15 height=15>


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts