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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Bob

    date formula not working correct

    Bob, Feb 22, 2004, in forum: Excel Beginners
    Replies:
    1
    Views:
    123
    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:
    99
    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:
    117
  4. Bo Rasmussen

    Worksheet_SelectionChange not working

    Bo Rasmussen, Dec 13, 2004, in forum: Excel Beginners
    Replies:
    1
    Views:
    177
    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:
    116
  6. hellokitty

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

    hellokitty, Apr 12, 2005, in forum: Excel Beginners
    Replies:
    4
    Views:
    82
    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:
    70
    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:
    117
    Jerry Cropanese
    Jun 27, 2005
Loading...