Removing shared workbook protection
 

Good morning all,
I have a shared workbook which is protected with a password. Now I would
like to make a copy of the file and remove the "shared" function as well as
the password. Unfortunately I do not have access to the password.
I have the tried the http://mcgimpsey.com/excel/removepwords.html password
remover, but it does work for share protection. Any suggestions?
Btw, I am working with Excel2000 (SP3)
Brgds & thx in advance, Thore

Can't you unshare the workbook first, then run J.E.'s code to unprotect the
workbook?

Thore wrote:

Good morning all,
I have a shared workbook which is protected with a password. Now I would
like to make a copy of the file and remove the "shared" function as well as
the password. Unfortunately I do not have access to the password.
I have the tried the http://mcgimpsey.com/excel/removepwords.html password
remover, but it does work for share protection. Any suggestions?
Btw, I am working with Excel2000 (SP3)
Brgds & thx in advance, Thore

--

Dave Peterson

No, this does not work because in the Share Workbook window I cannot deselect
the "Allow changes..." button.

I just saw that I forgot a "not" in my original posting: J.E.'s code
obviously does not work for the share protection. Otherwise I would not have
the problem.


"Dave Peterson" wrote:

Can't you unshare the workbook first, then run J.E.'s code to unprotect the
workbook?

Thore wrote:

Good morning all,
I have a shared workbook which is protected with a password. Now I would
like to make a copy of the file and remove the "shared" function as well as
the password. Unfortunately I do not have access to the password.
I have the tried the http://mcgimpsey.com/excel/removepwords.html password
remover, but it does work for share protection. Any suggestions?
Btw, I am working with Excel2000 (SP3)
Brgds & thx in advance, Thore

--

Dave Peterson

I misunderstood your first post, too.

I don't know away of breaking that shared workbook password.

You may want to check with the people at:
http://www.lostpassword.com

(I've never used it and it's not free.)



Thore wrote:

No, this does not work because in the Share Workbook window I cannot deselect
the "Allow changes..." button.

I just saw that I forgot a "not" in my original posting: J.E.'s code
obviously does not work for the share protection. Otherwise I would not have
the problem.

"Dave Peterson" wrote:

Can't you unshare the workbook first, then run J.E.'s code to unprotect the
workbook?

Thore wrote:

Good morning all,
I have a shared workbook which is protected with a password. Now I would
like to make a copy of the file and remove the "shared" function as well as
the password. Unfortunately I do not have access to the password.
I have the tried the http://mcgimpsey.com/excel/removepwords.html password
remover, but it does work for share protection. Any suggestions?
Btw, I am working with Excel2000 (SP3)
Brgds & thx in advance, Thore

--

Dave Peterson


--

Dave Peterson