Tom Black
asked on
A particular cell that changes triggers a macro
I need to trigger a macro only if Summary.range("B13") changes. Summary is sheet 5
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
put this code into Summary sheet object
Glenn I was first :-)
you were few second late :-)
you were few second late :-)
Yep; that's what I get for creating a pretty graphic. :-P
-Glenn
-Glenn
ASKER
Tried it and ANY cell that changes on the Summary sheet triggers the private sub.
You'll have to show us your code; if you used either Flora20's or my example, it would only happen if cell B13 of Sheet5 (Summary ?) was changed.
-Glenn
-Glenn
can you check the attached file.
F--F--Book1.xlsm
F--F--Book1.xlsm