unprotect workbook or sheet

O

Onur Ekinci

I try to see the formulas behind a cell.Since the sheet or
workbook is protected I couldnt see it.This is the old
file and I forgot the unprotect password.How can I
unlock ??Thank you.
 
J

Jim Rech

You can just select all the sheet's cells and copy/paste them to a new
worksheet.

Another approach is to run this macro:

http://j-walk.com/ss/excel/faqs/pw.txt

--
Jim Rech
Excel MVP
|I try to see the formulas behind a cell.Since the sheet or
| workbook is protected I couldnt see it.This is the old
| file and I forgot the unprotect password.How can I
| unlock ??Thank you.
 
Top