Unprotecting a work sheet with out knowledge of pass word.

[William]

I have inherited a file at work that has a protected work sheet with a pass
word. Employee that set this up has long left the company. Does any one
have a suggestion on how to unprotect the work sheet.

 

[Shane Devenshire]

Hi,

We are talking worksheet not workbook?

1. Insert a new sheet in the workbook.
2. Select the entire original worksheet and press Ctrl+C
3. Switch back the the new sheet and press Ctrl+V

The new sheet will be unprotected. After making sure everything works
delete the original sheet.

If this helps, please click the Yes button.

cheers,
Shane Devenshire

 

[Dave Peterson]

You may want to read JE McGimpsey's notes on protection:
http://mcgimpsey.com/excel/removepwords.html