JE
A second question/problem. I made up a dummy file with 3 sheets. I
protected the file and each sheet with passwords, different passwords in
each case.
The code removed the sheet protections and the associated passwords, but
it did nothing about the workbook-open protection or password. In fact, a
MsgBox at the start said that the file did not have protection for workbook
structure or windows. When I now run the code again, the MsgBox says that
the file does not have sheet or workbook structure or window protection.
Did I miss something?
Thanks again for your help. Otto
"Otto Moehrbach" wrote in message
...
JE
I went to your site:
http://www.mcgimpsey.com/excel/removepwords.html
Very useful.
I have one question. In the remarked-out text with the code, you say
"Reveals hashed passwords NOT original passwords".
You lost me there. What are "hashed passwords" and what are "original
passwords"? Thanks for your help. Otto
"JE McGimpsey" wrote in message
...
See

http://www.mcgimpsey.com/excel/removepwords.html

In article ,
Bryan wrote:

Hi,

Got a bit of a problem with a protected worksheet. The person who
created
the sheet has now left my company and we need to access it to update it
with
new formulas. Is it possible to do this without a password e.g. saving
the
sheet as a seperate name - or do we have to re-build the entire sheet
from
scratch?

thanks,
Bryan