Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Remove Password Protection from Excel 2010 Worksheet

  1. #1
    Board Regular
    Join Date
    Apr 2010
    Posts
    523
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Remove Password Protection from Excel 2010 Worksheet

    Hi All

    I have created a worksheet and password protected, I know the password but now want to send to someone and remove the password protection option instead of them having to use a password to open it.

    Any help on this would be very much appreciated

    Regards
    Donal
    0 0
     

  2. #2
    MrExcel MVP VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Remove Password Protection from Excel 2010 Worksheet

    On the Review tab click on unprotect worksheet.
    HTH, Peter
    Please test any code on a copy of your workbook.
    0 0
     

  3. #3
    Board Regular
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    189
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Remove Password Protection from Excel 2010 Worksheet

    If you know the password, just do a save as, I forget where in 2010 but there should be something that says general options, then password to open & password to modify. Just make those blank and save.

    I'm assuming you password protected the whole file since you said "to open" and not just the worksheet. Otherwise, do what is stated above.
    Robert Gama
    0 0
     

  4. #4
    Board Regular
    Join Date
    Apr 2010
    Posts
    523
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Remove Password Protection from Excel 2010 Worksheet

    Hi All

    Thanks for the replies, For some reason I am not seeing the unprotect worksheet worksheet option I think the second option is the best here.

    Thanks for your help

    Donal
    0 0
     

  5. #5
    New Member
    Join Date
    May 2012
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Remove Password Protection from Excel 2010 Worksheet

    Dear SIR.

    I AM SO MUCH CONFUSE and upset.can u help me plz.

    i protect my work in excel 2007. but i forget my password.and i am so worried about it,because i have alot of done in this sheet.please help me.
    0 0
     

  6. #6
    MrExcel MVP VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Remove Password Protection from Excel 2010 Worksheet

    Quote Originally Posted by nav770 View Post
    Dear SIR.

    I AM SO MUCH CONFUSE and upset.can u help me plz.

    i protect my work in excel 2007. but i forget my password.and i am so worried about it,because i have alot of done in this sheet.please help me.
    Sorry we cannot answer that. See #20 http://www.mrexcel.com/forum/showthread.php?t=127080
    HTH, Peter
    Please test any code on a copy of your workbook.
    0 0
     

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com