Forum Discussion

Copper Contributor

Jan 15, 2020

Solved

Unprotect workbook

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 bu...

excel

jamieintheATX
Jan 15, 2020
Riny_van_Eekelen Brilliant. That worked. Thank you so much!

Riny_van_Eekelen

Platinum Contributor

Jan 15, 2020

jamieintheATX

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

Balaji_B2019

Copper Contributor

Jun 29, 2020

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

Riny_van_Eekelen
Platinum Contributor
Jun 29, 2020
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.
- Aragan29
  Copper Contributor
  Jan 25, 2021
  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.
  - Riny_van_Eekelen
    Platinum Contributor
    Jan 25, 2021
    Aragan29 What Excel version are you on? Please upload a screen shot of what you see when you select File, Save As....