Results 1 to 6 of 6

Remove Password Protection from Excel 2010 Worksheet

This is a discussion on Remove Password Protection from Excel 2010 Worksheet within the Excel Questions forums, part of the Question Forums category; Hi All I have created a worksheet and password protected, I know the password but now want to send to ...

  1. #1
    Board Regular
    Join Date
    Apr 2010
    Posts
    485

    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

  2. #2
    VoG
    VoG is offline
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,537

    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.

  3. #3
    Board Regular
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    187

    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
    Excel 2007 & 2010
    Screen captures are taken with SnagIt, and stored in a public DropBox folder.
    Get your own Dropbox account here. 2GB account is free! http://db.tt/Y88u8a0

  4. #4
    Board Regular
    Join Date
    Apr 2010
    Posts
    485

    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

  5. #5
    New Member
    Join Date
    May 2012
    Posts
    1

    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.

  6. #6
    VoG
    VoG is offline
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,537

    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 Guidelines for posting (updated 22 Nov 2006)
    HTH, Peter
    Please test any code on a copy of your workbook.

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