Need a code to unprotect the workbook from different workbook. help

Status
Not open for further replies.

Aleng

New Member
Joined
Jul 27, 2010
Messages
37
I have a code to remove password or unprotect sheet but not the workbook.
If anyone here has some idea, please help, thank alot!;)
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Simon Lloyd

Well-known Member
Joined
Sep 10, 2006
Messages
756
Breaking workbook security questions are frowned on, what's your purpose?, if you own the workbook you will know the password.
 

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
May be the user might have forgotten the password....:biggrin:
do u have the answer????
 

Simon Lloyd

Well-known Member
Joined
Sep 10, 2006
Messages
756

ADVERTISEMENT

If the user has forgotten the password they can copy all the data ...etc to a new workbook, you do not need the workbook password for that.
 

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
What if the worksheet was completly protected...lol:biggrin:!

Nothing agianst "u" but i think the user itself does not bother to check in anymore....:p
 

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
Great....
hehehe...
Let me try your code...
:)

Jokes apart...any idea????
I also have the code to unprotect the sheet only but was curious when this code came in...may be it can be very usefull in different ways...dependent on the users intention....:biggrin:

Ped
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,118,168
Messages
5,570,605
Members
412,330
Latest member
carlosjw
Top