Protected sheet to unprotected sheet

[[email protected]]

I have a worksheet in Excel 2002 which is protected (as is the
workbook) and the person that protected it is not with our company
anymore. I need change the worksheet to update it and would just like
to copy it to a new one, but cannot figure out how to copy it without
copying the protection. Any help would be appreciated.

Michael

[goober]

If you can select all the cells on a sheet, open a blank workbook, select all the cells you want to copy from the original worksheet and then copy and paste them into the new workbook. If this won't work you could always find a brute force program to recover the lost passwords. HTTP://www.lostpassword.com is a good place to start.

[GerryK]

You could try to highlight the whole sheet (top left corner), copy and paste
to a blank sheet or new workbook.

HTH
GerryK

"[email protected]" wrote:

> I have a worksheet in Excel 2002 which is protected (as is the
> workbook) and the person that protected it is not with our company
> anymore. I need change the worksheet to update it and would just like
> to copy it to a new one, but cannot figure out how to copy it without
> copying the protection. Any help would be appreciated.
>
> Michael
>
>