Excel - Macro repeats on Worksheet Change
Closed
ja6924
-
Apr 21, 2010 at 12:06 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 21, 2010 at 12:14 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 21, 2010 at 12:14 PM
Related:
- Excel - Macro repeats on Worksheet Change
- Transfer data from one excel worksheet to another automatically - Guide
- How to change date format in excel - Guide
- How to change author in excel - Guide
- Change computer name cmd - Guide
- Spell number in excel without macro - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 21, 2010 at 12:14 PM
Apr 21, 2010 at 12:14 PM
Add at the start of the code
Application.EnableEvents = False
and at the end of the code
Application.EnableEvents = true
Application.EnableEvents = False
and at the end of the code
Application.EnableEvents = true