+ Reply to Thread
Results 1 to 5 of 5

macro password

  1. #1
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    macro password

    Hello to all.
    The attached macro is activated upon expiry of a certain date and requires a new password.
    The new password is given username + Clock (example for today = usernamen17 / 03/2017 (dates italian))
    I ask for a change:
    For each daily incorrect entry number in the message needs to increase:

    "Attempt # ...",

    Please Login or Register  to view this content.
    after the fifth attempt should display a message:

    "Today you can not try, try again tomorrow" '<<<<< This notice is for a joke

    Here in counter will reset and start again from #1
    I am attaching the example.
    I hope I explained.
    A greeting.
    max_max
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: macro password

    Try this:

    Please Login or Register  to view this content.
    Regards,
    Stephen

    If you feel someone has helped you please thank them and click on the star on their post to add reputation.
    Please ensure that you use code tags where relevant, and mark solved threads as solved.
    Most of all please be respectful and understanding of others.

  3. #3
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: macro password

    Hello spitfire blue,
    your macro works.
    I can not put your macro in my macro
    A help?.

    Please Login or Register  to view this content.
    max_max

  4. #4
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: macro password

    Maybe start with mine and then add the bits in from yours?
    What else do you want it to do?

  5. #5
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: macro password

    Hello spitfireblue,
    Now your macro work with my macro.
    Now it is OK.


    Please Login or Register  to view this content.

    A greeting and thanks.
    max_max

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 05-27-2014, 02:40 PM
  2. macro that inputs the password on a password protected document
    By dandavis1 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-09-2014, 10:12 AM
  3. Replies: 6
    Last Post: 02-09-2013, 03:06 AM
  4. password protection-is there anyway to put a password on running a macro in excel?
    By Solarissf in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2008, 10:06 AM
  5. [SOLVED] How to see macro code of a password protected macro without a password?
    By Dmitry Kopnichev in forum Excel General
    Replies: 5
    Last Post: 10-27-2005, 05:05 AM
  6. [SOLVED] How to see macro code of a password protected macro without a password?
    By Dmitry Kopnichev in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-27-2005, 05:05 AM
  7. [SOLVED] How to see macro code of a password protected macro without a password?
    By Dmitry Kopnichev in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-27-2005, 05:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1