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

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 he
http://www.mcgimpsey.com/excel/removepwords.html

--
Regards,
Tom Ogilvy



"Scott O'Donnell" wrote in message
...
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,

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

Scott

On Sun, 3 Oct 2004 17:30:09 -0400, "Tom Ogilvy"
wrote:

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 he
http://www.mcgimpsey.com/excel/removepwords.html