Hi I have been debugging a program that uses a button to activate a selected macro. If the user double clicks the button the macro will run twice and boy what a mess. Is there a way to make the button respond only to the first click or code to have the macro ignore the second click?
Help will be much appreciated.
Muzza1
Sounds like the user is clicking the button twice rather than "double clicking"
maybe a msgbox at the start of the code to ask user if they want to run the code
or a msgbox at the end of the code to let the user know the code has run
ergo.. taking the ability for the user to running the macro twice in succession without them wanting to
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
You could use this approach. The user will click the button only once.
Another approach might be some variation on this:
Please Login or Register to view this content.
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks