self-renewal password in Excel
self-renewal password in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: self-renewal password in Excel

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    99
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have two concerns. Excel's password feature can be disabled once you know the password. Second, if not diabled, it is the same password at all times. Well, I want to create a self-renewal password for opening an excel file. For every 15th days of the every month, the password changes itself. For ex: the original password is "temp11". If the file is open AFTER the 15th day of month April, it creates the next password such as "temp23". The format of the password is similar: always "temp" plus "increment of 1" plus "ascending prime numbers". However, it must have a permanent master password to disable the self-renewal password. My client knows the self-renewal password but not the master one. Any advise?

    Best regards,
    T. Le



    [ This Message was edited by: trillicomm on 2002-03-19 16:06 ]

    [ This Message was edited by: trillicomm on 2002-03-19 16:13 ]

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    73
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I don't think is possible to do this with the Excel protection...

    u need to do it with a dialog box and coding... that should do.

    good luck

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    99
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I totally agree with you. How to code that is what I am interested.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    No reason why you can have password chage to pre defind PW on > 1st jan or > 15 jan or > 1 feb etc

    but your need to know the new password, odd that, so you need to memorise many passwords, or be sneeky.

    If this is sheet protection add cqll in autoopen so password jumps.

    if module.. not so easy.. .

    remember passwords can be opened cracked, regardless..

    take some VBA to do this thou....
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    99
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The file has 27 sheets and I don't have any module. I am still clueless.

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Module is where the code is places,

    Auto_open calls the reqd code, or can really be in auto_open i guess..

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Posts
    99
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am sorry...I am still clueless. I am not a VBA expert. I need more step by step advise. Thank you.

  8. #8
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Trillicom,

    that prime number bit may be a bit of a drag..... unless you have a pretty big database of existing prime numbers, you're going to have to have excel figure out the next one...

    since a prime number is not divisible by anything except itself and "1", you need to check that it's not divisible by all the integers between 3 and it's own square root. Asking excel to do this may take some time and thusly affect it's performance...even via VBA, as each new password requires this whole checking procedure up to the next prime number....



  9. #9
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thus my comments, no reason why password 1 cant change to password 2 in 15 days, bit still a crude idea...
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com