Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My Shared workbook is driving me crazy!!! | Excel Discussion (Misc queries) | |||
Shared workbook - one at a time? | Excel Discussion (Misc queries) | |||
workbook protection | New Users to Excel | |||
Shared workbook protection | Excel Discussion (Misc queries) | |||
Problem with shared workbook (history sheet) | Excel Worksheet Functions |