How to speed up my code
Solved/Closed
Related:
- How to speed up my code
- Need for speed undercover registration code ✓ - Forum - Video Games
- 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 - Internet/Social Networks
- Chineese internet codes ✓ - Forum - Mobile
- Airtel internet speed ✓ - Forum - Network
- Need For Speed Undercover Problems ✓ - Forum - Video Games
1 reply
rizvisa1
Jul 23, 2010 at 06:09 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jul 23, 2010 at 06:09 PM
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
Jul 27, 2010 at 08:55 AM
Kind regards,
Trowa