Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!
Subscribe for Free Excel tips & more!

Remove Document Password In Excel 2010

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

I have a document that was created in Excel 2010 and requires a password to open. How do I remove the password so that it is no longer required?

View Answers     

Similar Excel Tutorials

Password Protect Excel Files
How to keep an Excel workbook safe by encrypting it with a password. This will make it so that a user cannot open ...
Password Protect Excel VBA Macros
How to password protect VBA code and macros in Excel so that a user cannot see the code or edit it or do anything ...
Allow Only Certain People to Edit Specific Cells in Excel
How to allow only certain people to edit certain cells or ranges in Excel. This is a security feature that you can ...
Remove Personal Information from Excel Files
How to remove all personally identifiable information from an Excel file. When a file is created in Excel, it auto ...

Helpful Excel Macros

Protect and Unprotect All Worksheets at Once
- This will allow you to protect or unprotct all worksheets in a workbook at once. It doesn't allow you to input a passwor
Hide Formulas in a Worksheet and Prevent Deletion
- This macro will hide all formulas within a workbook and not allow them to be deleted. The page will not be protected li
Open a Word Document from Excel
- This Microsoft Excel macro will open a Microsoft Word document from excel. With this macro, you can open any word docume
Open Microsoft Word from Excel
- This free macro will open the Microsoft Word program on your computer. You do need to have this program first. This wi
Remove Comments from a Workbook in Excel - All Comments Deleted - Macro VBA
- Excel macro that will remove/delete all of the comments from an entire Excel workbook. This means that this macro will

Similar Topics

I have an old MS word document that I set to prompt for password for it to open. Unfortunately I cant remember the password and have tried all the passwords I've been using as far as I can remember. Tried the password recovery tools in the web but to no avail.
By any chance how can I remove the password so that I could open the document anew.


Hey Guys,

Our company is using sharepoint, so we no longer need to keep passwords on our excel files. Also, we just recently upgraded from 03 to 07. However, we can't find out how to remove the workbook password in excel 07. To be clear, Im not talking about the password to let you edit items in the sheets and what not. Im talking about the password you are prompted for BEFORE the workbook is even opened! It will say "test.xls is reserved by JSA715 Enter password for write access, or open read only."

I've tried all of the password options under the review tab, none of them work.


Hi All,

I have an MS Excel 2010 xlms file which is password protected. Unfortunately, the person who has the password has left the company!

Which is the best tool to remove the password / recover the file? I don't mind paying a premium (doesn't have to be free) and from a reputable source.

Many thanks,

I am using Excel 2003.

I have a workbook with password protection for opening. When I open it, Tool>Option>Security shows the password as asterisks. I remove them. I then SaveAs and under Tools, General Options, Remove the Asterisks for Password to Open. I then continue with the save.

Then I check that the password has been removed, but it has come back.

I have put an Exit Sub as the first line of my Before_Save code so I know that the code is not doing anything.

Does anyone know what stops me from removing the password to open the file.


I have a VBA project coded by one of my co-workers who left our company last month. He however gave me the password to open the project before he left. Now I think this VBA project no longer needs protecting, therefore I want to remove the protection. I know for an Excel worksheet, it is very easy to remove the protection if you know the password and want to remove it. Simply open the Excel workbook by using the password and then go to tool --> option --> security ...

Is there an easy way to remove the protection for the VBA project because I have already had the password?

Thanks for help!!!



I'm hoping someone can help me here! I have an Excel document that is viewed by approximately 200 users. For obvious reasons I only want them to have read only access however I use and update the document regularly throughout the day.

Previously when the document was on Excel 2003 I would go to Tools/Options and select from there to add a Password to either Modify or Open.

I'm now using Excell 2007 and I can't seem to find the same function. I know there is one section when saving a document as "Save As" that will allow me to do this however I don't to have to create a new document every time I add a password. Likewise I know I can go onto my drive and right click the document to "Read Only" but this seems a bit of a clunky way round it rather than just adding a password.

The Microsoft help pages say to go to menus that don't exist so I'm a bit confused!!

Hi All,
I Have a macro enabled workbook and i am trying to set it that only people with the password can open the file, I can set the password for modifying the file but when i set it for opening the file, i get this message;

"This workbook contains Excel 4.0 macros or Excel 5.0 modules. If you would like to password protect or restrict permission to this document, you need to remove these macros."

But i cannot remove these macros as they are integral to the sheet...!!!

Please help!!!

Hi, I accidentally placed a password in my workbook. Now, every time I open the xlsm file, it requires me to input a password. (thankfully i was able to guess the password.) I tried protecting and unprotecting the workbook using the one under review tab, but it's still there. This happened after tinkering the macros. Any ideas?

I have created a worksheet some time ago and protected certain cell within it
and gave the worksheet a password in order to edit it. Unfortunately I can
no longer remember the password and to save me creating the worksheet again
it would be better if there was a way round this or a small program that will
remove the password for me. Your help is appreciated.

I found a function to set the password a an excel file:

Function SetPwd(strNoPwdFile As String, _
strPwdFile As String, _
Optional strOpenPwd As String, _
Optional strModPwd As String) ' As Boolean
' This function requires the following arguments:
' strNoPwdFile - The path to a document without a password.
' strPwdFile - The path and name to save the password-
' protected document.
' This function accepts the following optional arguments:
' strOpenPwd - A case-sensitive password required to open
' the document.
' strModPwd - A case-sensitive password required to modify
' the document.
On Error GoTo SetPwd_Err
Documents.Open FileName:=strNoPwdFile
With ActiveDocument
.SaveAs FileName:=strPwdFile, _
Password:=strOpenPwd, _
End With
SetPwd = True

Exit Function

MsgBox "Error #: " & Err.Number & vbCrLf _
& Err.Description

Resume SetPwd_End

End Function

And I have the following visual basic code to call the function :

Sub main()
End Sub

But the compiler said that it is syntax error.

How can i rectify the error ?

I have an excel spreadsheet which when I try to remove the workbook protection asks for a password. Unfortunately I have forgotten the password. I have downloaded numerous software which claim to be able to remove the password but as yet none of them have worked. Can anybody help?


I am new to this site. I did not find anything this fit under, so I am very sorry if this in the wrong section to post. I have an spreadsheet in a .xlsx format with a password on it. No other sites are helping because they all know the password and just want to disable it. I can't even look at the document, and I don't have the password. Nothing else is related to my case that I found, so I need help getting the password off. I use office 2010 for this file format. Please reply fast. I am good with computers and know a lot more than a lot of people, but please don't get technical on me, I'll get lost.

Thanks for the help,

Hy everyone,
I need help.
I want to make vba code that will set up password protection for opening word document, also that key for opening should be written on the document, because document is suposed to be printed and then taken to someone who would have to open the same document on some shared server and add some text. only person who get the document physicaly should be able to open the same document on web.
I have never programmed before in vba, and i would aprecieate any help.

Hi all,

I have a a macro that opens password protected documents on a network folder, applies the password, copies the contents to another workbook and then closes the protected document.

This all works perfectly when the workbook on the network folder is closed. However, when another user has that document open I get promoted to apply the password in order to open the workbook in 'read only' mode. Once the password is applied the macro continues with the copy/close process perfectly.

I would like to eliminate the step of manually applying the password if the document is open by incorporating it into the macro. Is this possible?

This is my macro at the moment:

Please Login or Register  to view this content.

Thanks for any advice.

My boss gave me an excel document with sensitive payroll information about all our employees in it. I want to password-protect the document so nobody else in the office can open/modify it.

For whatever reason, in the Save As dialog box undre General Options, the option to set a password for opening the document is disabled. Interestingly, the option for setting a password for modifying it is still there, but the one for opening the document is greyed out.

Another interesting characteristic about the document is that the option to Protect Sheet is disabled (2 sheets in the workbook - both are disabled from protection).

There are no macros defined in the workbook and I'm using Excel 2007. Any ideas greatly appreciated.

Can't Remove password protection
I inserted the following code into one of my workbooks to password protect the document before closing which works great, however when I reopen the workbook I type in the password the workbook opens and then I try to remove the protection but it is stuck and in the protection it keeps saying that the workbook isn't protected. I then removed all macro code from the workbook and saved it as a different file name however it still stays protected and there is no way to remove the protection, can someone please help with this.

Application.DisplayAlerts = False
ThisWorkbook.Password = "jaye"
Application.DisplayAlerts = True
ThisWorkbook.Saved = True

Mr. Excel,

Am attempting to create a macro that requires the password "OPEN", before going from the current sheet (Instructions), to Sheet1.

currently using:

Sub SheetPassword()
Var1 = InputBox("Enter Password in this Input Box :", _
"Required Password", "OPEN")
On Error Resume Next
End Sub

Getting message: Compile Error, Expected End Sub.

Thank you in advance,

Can any one help me on how to remove password from xls file to open it. I have the file which is password protected. I forget the password. Any suggested free/trial software?.

Hi all,
I'm using a online submitted Excel speadsheet using as calender which is PASSWORD protected. Now I want to remove the password which I don't know how to do.

Can you help me?

Thanx in advance.

I have a excel file that a user password protected. The user left the company and i don't know the password. Is there a free way to remove the password without recreating the entire sheet.

thank you,


I set up a security measure (to keep me from doing something stupid on a spreadsheet), now every time i open the spreadsheet, i have to type in the password. I know that password, that's not the problem. I want to take the password completely off, its too much of a hassle and others can't open the document if i send it to them without the password. I can't remember how to do this!

The first window says "This template is protected."
then asks for the password.

After entering that password

The next window says "This template is reserved by me"
Enter password for write access, or open read only.

Please help me turn this off!

Hello All,

I have two excel documents that are password protected, they are both mine and I can't figure the dumb password out? any ideas of how to remove it or macro's maybe even freeware that can be used to remove them?


I use the below macro to open a specific password protected word document. When it runs, it opens the word document and a password box opens, but I have to click on them. What I'd like to do is modify it to minimize excel and activate the password box.

Please Login or Register  to view this content.

My wife set a password on an MS Word File, but forgot the password. Does anyone now how to by-pass it?

When I open the file, I am prompted for a password. When I type in what she thinks it is, it says its the wrong password and thats it it.. no document.


Hi All.

I have Excel 2010 file protected by password. Now I would like to remove password and make that file unprotected. I open file and select Review menu but unfortunately I didn't see in Changes ribbon Unprotect Sheet or Unprotect Workbook. What need to do to unprotect Excel 2010 file?