Forum Discussion
Unprotect workbook
Riny_van_Eekelen Brilliant. That worked. Thank you so much!
Password protection sits in "Save as". There you have "Options..." and you can choose to have no password.
I have 365, trying to remove workbook password. Not seeing an 'No password' option.
DaveD1360 I may have changed a bit since the original post. In 365, at the moment, I see it like this.
then,
choose General options and enter the password of your choice.
- 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.
hi Riny_van_Eekelen - where is the unprotect option in which tab - unable to find it
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.
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.
Riny_van_Eekelen Brilliant. That worked. Thank you so much!
