Unprotecting a Sheet

[Scott O'Donnell]

I had a colleague of mine leave a while back and he protected some
worksheets so users could not modify them. Does anyone have a snipit
of code to get the password?

thanks in advance,
Scott

 

[Tom Ogilvy]

Excel has a number of different passwords.

Can you open the workbook without a password. If so, then are there sheets
that you want to unprotect.

If so, you can use code found here:
http://www.mcgimpsey.com/excel/removepwords.html

 

[Scott O'Donnell]

Tom,

It was for a protected sheet. Thanks for the code, it worked great!

Scott