Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Oct 2007
    Location
    Beverly, USA
    Posts
    102
    Thanks
    0
    Thanked 1 Time in 1 Post

    removing protection from an Excel spreadsheet

    My boss has an excel spreadsheet that was probably generated in Excel 2003 (now being edited in Excel 2010) and he can't figure out how to remove the password to allow editing. (He can't let me try and work on the file because it's confidential).

    All the blog posts and support forum posts I have found suggest that he should be able to got to the review tab and select un-protect worksheet to remove the password, but there's not un-protect workbook option.

    Any ideas on where else the permissions might be hidden?

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,474
    Thanks
    211
    Thanked 848 Times in 780 Posts
    Chris,

    When the workbook is opened does it prompt for a password?
    And if so is he entering the Modify Password vs the Open R/O password?
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  3. #3
    2 Star Lounger
    Join Date
    Oct 2007
    Location
    Beverly, USA
    Posts
    102
    Thanks
    0
    Thanked 1 Time in 1 Post
    We've killed the "Open" password. Now we're looking to get rid of the "Modify" password.

  4. #4
    4 Star Lounger
    Join Date
    Jan 2004
    Location
    Heraklion
    Posts
    541
    Thanks
    2
    Thanked 46 Times in 44 Posts
    Open the Workbook using both passwords, then:

    File
    Save As
    Tools
    General Options

    . . . then clear both the boxes: "Password to open:" and "Password to modify:"

    That should do it.

Posting Permissions

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