Unprotect workbook

[jamieintheATX]

I have a workbook that was sent to me for my use but came password protected as it has sensitive information that was being sent by email. I have the password and have renamed and resaved the file but every time I open it, I again have to enter the password. When I go to "Protect Workbook" there is no option to unprotect and its the same if I look under Review in the ribbon. How can I get this file to stay unlocked?

[#2]

@jamieintheATX 

Password protection sits in "Save as". There you have "Options..." and you can choose to have no password.

[#3 · Accepted solution]

@Riny_van_Eekelen Brilliant. That worked. Thank you so much!

[#4]

hi  @Riny_van_Eekelen - where is the unprotect option in which tab - unable to find it

[#5]

@Balaji_B2019 The above thread deals with removing or changing a password to open a workbook. There is no button for it. As mentioned above, it is part of the "Save as" process. But allow me to expand my previous response. On a Mac: File, Save as, Options. On Windows: File, Save as, More options, Tools, General options.

[#6]

@Riny_van_Eekelen 

In my save as i don't have more options even though i am on windows. I couldn't find it under review or info as well.

[#7]

@Aragan29 What Excel version are you on? Please upload a screen shot of what you see when you select File, Save As....  

[#8]

I had a similar problem, and your instructions were very helpful - path for me (Windows 10) was Save as / More Options / tools / General Options with the menus all over the place, some at the top of the window, some at the bottom. Then I had to figure out to leave the password field blank! Anyway - Big Help - Thank you!

[#9]

Thank you! This solved a problem I have as well. It is a bit different, but your solution worked. I have a previously protected workbook that has now been unprotected, but I could not add any worksheets or change the structure of the workbook. Save as, options, and show all sheets solved the problem.