Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Password protected workbook (XP)

    I created a password protected workbook in version 97 inserting the password during the "save as" process. I have now updated my system to XP. Can't find how to unprotect the workbook to give it to another user without his being requested to enter the password. Can anyone help?

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Password protected workbook (XP)

    I'm assuming you remember the password. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Choices
    1) unprotect the workbook, save and give to the user.
    2) give the protected workbook and the password to the user.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Password protected workbook (XP)

    Select Tools>Options...
    The password options are on the security tab

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password protected workbook (XP)

    Don't know about XP since I don't use software that includes the Registration/Activation Wizard, but I think that you should be able to do a SaveAs to a new file and not specify a password.
    Legare Coleman

  5. #5
    Star Lounger
    Join Date
    Jan 2001
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password protected workbook (XP)

    Thanks Legare,
    Yours was the simplest and easiest solution. My problem was that I was familiar with Excel 97 after years of use but unfamiliar with the XP version which uses a different method to perform password protection and unprotection.

Posting Permissions

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