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!;)
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

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.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,546
Messages
5,838,034
Members
430,527
Latest member
MyFace2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top