Disabling Control Button After It has been clicked once
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Disabling Control Button After It has been clicked once

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have aspreadsheet that contains a control button to enable the user to eamil the sheet by clicking on the button. How do I disable this after it has been pressed to prevent multiple copies being emailed by enthusiastic mouse clickers. Is it also possible to dim the control button or change it's colour once it has been clicked?

    Thanks

    Craig

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    In the click event sub of your command button, add the following at the end, this will also grey out the button: -

    CommandButton1.Enabled = False

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