Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Aug 2005
    London/Kingston, Surrey, United Kingdom
    Thanked 0 Times in 0 Posts
    Hi all,

    I have a macro when I run it it used to create random password for each sheet and then save the password the lists of passwords on a new workbook, but now it is creating the passwords but it is not saving the list on book1 and I dont know why as I did not change anything. see the attached macro.

    help please

    many thanks
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Weert, Limburg, Netherlands
    Thanked 0 Times in 0 Posts
    You must have posted the wrong macro, because there is nothing in the code that saves the password list to another workbook. All it does is:
    For each sheet:
    - unprotect using pw in cell K2
    - create new pw
    - protect using new pw
    - save new pw in cell K2 of sheet.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    Professional Office Developers Association

Posting Permissions

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