+ Reply to Thread
Results 1 to 5 of 5

Disable Button after one click user wise

  1. #1
    Registered User
    Join Date
    07-08-2011
    Location
    USA
    MS-Off Ver
    MS Office Home and Student 2019
    Posts
    25

    Disable Button after one click user wise

    Hey Guys,

    With limited knowledge in vba, I've created a timesheet with userform to complete the login, logout details. Need help in disabling the buttons for each users for multiple click.

    For example, if a user has already clicked on Login button, he/she should not be allowed to click again

    Request your help

    Attached is my file

    Thanks
    Keerthi
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-27-2011
    Location
    Manchester, England
    MS-Off Ver
    Excel 2003
    Posts
    40

    Re: Disable Button after one click user wise

    Hi,

    Your vba is protected and when I click login it crashes. If you need to disable a button use:

    commandbutton1.enabled = False
    Regards
    MrExcelPro

  3. #3
    Registered User
    Join Date
    07-08-2011
    Location
    USA
    MS-Off Ver
    MS Office Home and Student 2019
    Posts
    25

    Re: Disable Button after one click user wise

    Thanks for immediate reply. I've used CommandButton1.Enabled = False for all options however if I close the file and re-open, it allows to click again.

    Attached is the unprotected file. If it still ask for pw, enter "time"
    Attached Files Attached Files

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Disable Button after one click user wise

    You need to save some sort of response to the Registry, the workbook, text file or maybe a Named range. Then the userform refers to that to check
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  5. #5
    Registered User
    Join Date
    07-08-2011
    Location
    USA
    MS-Off Ver
    MS Office Home and Student 2019
    Posts
    25

    Re: Disable Button after one click user wise

    Thanks Roy...

    Am new to vba and in learning curve. Could you please explain in detail the code or if possible update in the file itself. Will learn for any future requirements

    Your help will be greatly appreciated

    Thanks
    Keerthi

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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