Is there a "ChangeCell" event?
I have a pulldown list of values. I need to run a macro whenever the value
of the cell with the pulldown changes.
For example, If the cell is changed from "Master" to "Balance", I need a
macro to run to unhide certain sheets and hide others. The macro (vba code)
is not the problem - it's just having excel execute the code if the cell
value changes.
Any help in pointing me in the right direction is appreciated!!
|