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

Status
Not open for further replies.
Aleng

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

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Sort by date Sort by votes
Breaking workbook security questions are frowned on, what's your purpose?, if you own the workbook you will know the password.
 
Upvote 0
May be the user might have forgotten the password....:biggrin:
do u have the answer????
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
weskty22 said:
Great....
hehehe...
Let me try your code...
:)
Click to expand...

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
 
Upvote 0
Status
Not open for further replies.

Similar threads

R
  • Solved
Unprotect Sheet code runs, but doesn't unprotect sheet
Replies
3
Views
106
RockandGrohl
R
SaraWitch
  • Question
Unprotect/protect all worksheets with a checkbox
Replies
3
Views
558
skillilea
S
P
  • Question
Incorrect Password still runs macro
Replies
3
Views
232
PaulWJ
P
A
  • Question
VBA to run in Protected Workbook
Replies
5
Views
170
bobsan42
bobsan42
I
  • Solved
Copy and Paste from One workbook to another
Replies
3
Views
426
ipon70
I

Forum statistics

Threads
1,214,528
Messages
6,120,065
Members
448,942
Latest member
sharmarick

Share this page

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
Back
Top