How to speed up my code
[Solved/Closed]
Related:
- How to speed up my code
- Hi! please save the internet settings sent to you and enjoy vi high speed giganet. your code is 1234. click bit.ly/viapp21 for d ✓ - Forum - Internet/Social Networks
- Hi! please save the internet settings sent to you & enjoy vi high speed giganet. your code is 1234. click bit.ly/viapp21 for dat ✓ - Forum - Mobile
- Need for speed undercover registration code ✓ - Forum - Video Games
- Need for speed most wanted code installation ✓ - Forum - Video Games
- I want internet settings for high speed - Forum - Internet/Social Networks
1 reply
rizvisa1
- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
Your issue are the events. As the code is running, all sort of events are fired up
Worksheet_Change
and Selection_change etc
Now I dont know if you do want the code to fire these events as macro is running or do you want to do it if the user does some thing.
If you want to disable events while code is running, you can add a line
Application.enableevents = false
and once the code is done running, add
application.enableevents = true
Worksheet_Change
and Selection_change etc
Now I dont know if you do want the code to fire these events as macro is running or do you want to do it if the user does some thing.
If you want to disable events while code is running, you can add a line
Application.enableevents = false
and once the code is done running, add
application.enableevents = true
Kind regards,
Trowa