Protected sheet to unprotected sheet

C

CaptainIrony

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
 
G

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

GerryK

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

HTH
GerryK
 
Top