Remove Password Protection from Excel 2010 Worksheet

Status
Not open for further replies.

Donal28

Well-known Member
Joined
Apr 23, 2010
Messages
527
Hi All

I have created a worksheet and password protected, I know the password but now want to send to someone and remove the password protection option instead of them having to use a password to open it.

Any help on this would be very much appreciated

Regards
Donal
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
If you know the password, just do a save as, I forget where in 2010 but there should be something that says general options, then password to open & password to modify. Just make those blank and save.

I'm assuming you password protected the whole file since you said "to open" and not just the worksheet. Otherwise, do what is stated above.
 
Upvote 0
Hi All

Thanks for the replies, For some reason I am not seeing the unprotect worksheet worksheet option I think the second option is the best here.

Thanks for your help

Donal
 
Upvote 0
Dear SIR.

I AM SO MUCH CONFUSE and upset.can u help me plz.

i protect my work in excel 2007. but i forget my password.and i am so worried about it,because i have alot of done in this sheet.please help me.
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,213,536
Messages
6,114,215
Members
448,554
Latest member
Gleisner2

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