+ Reply to Thread
Results 1 to 14 of 14

Remove Password Protection in Excel 2010 when no visible sign password is set

  1. #1
    Registered User
    Join Date
    10-18-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Remove Password Protection in Excel 2010 when no visible sign password is set

    I have a workbook that is password protected. There are no obvious signs that a password is set on the workbook.

    When the workbook opens the "Protect Workbook" feature under "Info" isn't highlighted. I've clicked on all the options under the feature and no password is set.

    I've looked on the Review Tab and none of the password protection features are highlighted. However, I did go through and check to see if anything was selected thinking perhaps the highlighting was just not working.

    I have the password, that's not the issue. The issue is this is a public document, no it's not set up as a "shared" workbook so that's not password protected either. People need to be able to view and add to the workbook without knowing my password. Where else can I look?

    The workbook was created by someone else and I inherited it, they assigned the password. That person has since moved on so I can't ask them what they did.

    I've never run into this before.
    Thanks in advance for your help.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2211 (Windows 11 22H2 64-bit)
    Posts
    65,444

    Re: Remove Password Protection in Excel 2010 when no visible sign password is set

    Just be aware that we are not able to help you to circumvent any security on the workbook, as it's against the forum rules. However, I don't believe this is what you are asking us to do.

    How do you know that a password has been set? At what point are you being asked for it?

    If you ARE asking us to help you crack the password, then I am afraid that this thread will have to be locked. Please confirm.
    Last edited by AliGW; 04-05-2017 at 09:45 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar but I could be everywhere
    MS-Off Ver
    All on PC except 365
    Posts
    10,029

    Re: Remove Password Protection in Excel 2010 when no visible sign password is set

    Attach the password "protected" file (if you know the password as you said)
    sandy
    I want to see what you are trying to achieve, not how you are trying to do it
    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  4. #4
    Registered User
    Join Date
    10-18-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Remove Password Protection in Excel 2010 when no visible sign password is set

    No, I have the password to the workbook. What I need to do is get it removed from the workbook so others in my department can access the workbook without my password.

    There are none of the "regular" signs that there's a password assigned to the workbook - the features under the review tab are not highlighted and when I check under "Info", "Protect Workbook" there's no password assigned there so I don't know how my password is assigned. I inherited the workbook a year ago and the person who gave the workbook to me assigned the password, which I have in my possession. I just want to remove it so the whole department can see and add to the workbook without my giving up my password.....

    No, I cannot upload the workbook. That would get me fired.........

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2211 (Windows 11 22H2 64-bit)
    Posts
    65,444

    Re: Remove Password Protection in Excel 2010 when no visible sign password is set

    OK, well there's not a lot we can do. The only thing I can suggest is that you look in any macros that have been set up in the workbook. If the password protection came from a macro in a different workbook that no longer exists, then you won't be able to get in, whatever you try, and as I said, however genuine your request might be, we cannot help you to crack it.

  6. #6
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar but I could be everywhere
    MS-Off Ver
    All on PC except 365
    Posts
    10,029

    Re: Remove Password Protection in Excel 2010 when no visible sign password is set

    one of possibility: check VBA Project (if you've password you should get access there)

    sorry, no see - no idea

  7. #7
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,346

    Re: Remove Password Protection in Excel 2010 when no visible sign password is set

    Are you entering the inherited password upon OPENING the workbook?
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  8. #8
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar but I could be everywhere
    MS-Off Ver
    All on PC except 365
    Posts
    10,029

    Re: Remove Password Protection in Excel 2010 when no visible sign password is set

    There is can be range protected also

  9. #9
    Registered User
    Join Date
    10-18-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Remove Password Protection in Excel 2010 when no visible sign password is set

    I believe I'm just going to copy and paste the content to a new workbook and be done with it. I've never seen this happen before.

  10. #10
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar but I could be everywhere
    MS-Off Ver
    All on PC except 365
    Posts
    10,029

    Re: Remove Password Protection in Excel 2010 when no visible sign password is set

    You can delete content (check if password still exist) and publish empty file here
    Last edited by sandy666; 04-05-2017 at 10:06 AM.

  11. #11
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,346

    Re: Remove Password Protection in Excel 2010 when no visible sign password is set

    I suspect a password to---> OPEN / MODIFY

    yup the file is needed..... btw what is the extension name is it pure .xlsx ?

  12. #12
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar but I could be everywhere
    MS-Off Ver
    All on PC except 365
    Posts
    10,029

    Re: Remove Password Protection in Excel 2010 when no visible sign password is set

    @Vlady
    You mean something like this?
    pass.jpg

  13. #13
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,346

    Re: Remove Password Protection in Excel 2010 when no visible sign password is set

    yup Sandy. I suspect he opens the file for the other users.

  14. #14
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar but I could be everywhere
    MS-Off Ver
    All on PC except 365
    Posts
    10,029

    Re: Remove Password Protection in Excel 2010 when no visible sign password is set

    So that is simply to remove
    while open type password, while Save set General Options, delete password (dots) , uncheck read only, save as different name and that's all
    genop.jpg
    Last edited by sandy666; 04-05-2017 at 10:27 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 15
    Last Post: 02-14-2017, 02:13 AM
  2. [SOLVED] Remove password protection
    By BRISBANEBOB in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2014, 11:31 PM
  3. Replies: 1
    Last Post: 03-11-2013, 05:44 PM
  4. Remove password protection
    By dgaller in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-16-2012, 06:59 PM
  5. Excel 2010 VBA password protection / encryption?
    By jmwbowen in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-30-2011, 05:06 AM
  6. password protection-is there anyway to put a password on running a macro in excel?
    By Solarissf in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2008, 10:06 AM
  7. [SOLVED] How can I remove workbook protection with no password?
    By Tony in forum Excel General
    Replies: 1
    Last Post: 10-19-2005, 05:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1