sureshch001
New Member
- Joined
- Jul 14, 2021
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
Hi Sir/Madam
I have a user form (A) contains two Images to launch two other different user forms (B & C). Both images code will run when I click on them. If I click on second Image immediately when I already clicked on first Image, second image code also running and the user form (C) is launching. Once I close the user form (C), the user form (B) is launching. (Just imaging if I have more button clicks on user form and if I click at time all of them. )
How to prevent multiple button clicks immediately or stop running another macro when already a macro is running? Please advise.
regards
Suresh
I have a user form (A) contains two Images to launch two other different user forms (B & C). Both images code will run when I click on them. If I click on second Image immediately when I already clicked on first Image, second image code also running and the user form (C) is launching. Once I close the user form (C), the user form (B) is launching. (Just imaging if I have more button clicks on user form and if I click at time all of them. )
How to prevent multiple button clicks immediately or stop running another macro when already a macro is running? Please advise.
regards
Suresh