writerespassword is not working

Discussion in 'Excel Beginners' started by Moselle, Oct 9, 2013.

  1. Moselle

    Moselle Guest

    below is my code. when i clock my macro button. it will automaticall
    save my excel sheet but i can only open it with password. whenever i tr
    to open it with my wrirespassword. it just prompt the CAPS LOCKs error
    im new to excel and i totally have no idea why this happen when th
    password works well as i need to open it in writeable version wit
    wrirespassword. if i remove the password:= and just used th
    wrirespassword. it will auto save as open excel without encryp
    anything. please help me on this :(


    Sub SaveInvWithNewName()
    Dim NewFN As String
    ' Copy Invoice to a new workbook
    ActiveSheet.Unprotect 111
    ActiveSheet.Copy
    NewFN = "Users/cs/Desktop" & Range("E3").Value & ".xlsx"
    ActiveWorkbook.SaveAs NewFN, FileFormat _
    :=xlNormal, Password:="222", WriteResPassword:="333", _
    ReadOnlyRecommended:=False, CreateBackup:=False
    ActiveWorkbook.Close
    NextInvoice
    ActiveSheet.Protect 111

    End Su


    --
    Moselle
     
    Moselle, Oct 9, 2013
    #1
    1. Advertisements

  2. Moselle

    Moselle Guest

    ok!! i did it somehow loll


    --
    Moselle
     
    Moselle, Oct 9, 2013
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Bob

    date formula not working correct

    Bob, Feb 22, 2004, in forum: Excel Beginners
    Replies:
    1
    Views:
    112
    JE McGimpsey
    Feb 22, 2004
  2. Al Franz

    Format Phone Numbers Not Working ??

    Al Franz, Apr 13, 2004, in forum: Excel Beginners
    Replies:
    2
    Views:
    93
    Frank Kabel
    Apr 13, 2004
  3. Kayden

    Sort function for dates not working properly

    Kayden, Apr 22, 2004, in forum: Excel Beginners
    Replies:
    3
    Views:
    102
  4. Bo Rasmussen

    Worksheet_SelectionChange not working

    Bo Rasmussen, Dec 13, 2004, in forum: Excel Beginners
    Replies:
    1
    Views:
    168
    Harald Staff
    Dec 13, 2004
  5. A Lost Soul

    Excel VB 2000 not working in 2003

    A Lost Soul, Mar 21, 2005, in forum: Excel Beginners
    Replies:
    2
    Views:
    106
  6. hellokitty

    This should be simple but it's not working for me!

    hellokitty, Apr 12, 2005, in forum: Excel Beginners
    Replies:
    4
    Views:
    78
    Kenny Dee
    Apr 12, 2005
  7. andreas

    My filter is not working for numbers & text

    andreas, Jun 2, 2005, in forum: Excel Beginners
    Replies:
    1
    Views:
    64
    Debra Dalgleish
    Jun 2, 2005
  8. Jerry Cropanese

    Remove Subtotal In Macro Not Working

    Jerry Cropanese, Jun 27, 2005, in forum: Excel Beginners
    Replies:
    0
    Views:
    111
    Jerry Cropanese
    Jun 27, 2005
Loading...