Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    London, Gtr London, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Remove Password after opening w'book (2000)

    I have an excel workbook which only opens with a password. I have the password, but I want to remove it and save the file without needing to use a password.
    Somehow I cant see how to do this. Any help?
    Thanks
    Frank

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Remove Password after opening w'book (2000)

    Frank

    This was taken from MSKB and may help you


    Private Sub SetPassword()
    Dim strPassword As String
    strPassword = _
    ThisApplication.InputBox( _
    "Enter the new password: ").ToString
    ThisWorkbook.Password = strPassword
    End Sub
    Jerry

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Remove Password after opening w'book (2000)

    File - Save As
    [Tools] - General options
    Remove the password to open or password to modify
    <ok>
    <Save>

    Steve

  4. #4
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    London, Gtr London, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thanks Re: Remove Password after opening w'

    Thanks both of you - works well

Posting Permissions

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