Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,562
- Office Version
- 365
- 2016
- Platform
- Windows
When a user clicks a macro enabled shape in my worksheet, the code populates a value to a dynamic cell ("X#" where # is variable) on that worksheet. I have this code below, part of my worksheet change code in the worksheet module, that is supposed to trigger when that cell changes.
Assume the user clicks the macro enable button. dcomprow = 24. The value determined in the button click macro is passed to cell "X24". Should that action not trigger this code? Unfortunately, it is not.
Happy for any thoughts or suggestions.
Code:
If Not Intersect(Target, Range("$X$" & dcomprow)) Is Nothing Then '
Stop
Application.ScreenUpdating = False
mbevents = False
Unprotect
bdr_weather
Protect
mbevents = True
Application.ScreenUpdating = True
End If
Assume the user clicks the macro enable button. dcomprow = 24. The value determined in the button click macro is passed to cell "X24". Should that action not trigger this code? Unfortunately, it is not.
Happy for any thoughts or suggestions.