I Have a case where I want a macro to start whenever a certain cells changes, regardless of reason for cell change (i.e. user input or link change.
According to Excel Help, Worksheet_Change() should be my ideal solution, but it doesn't seem to fire when the value in linked cells changes.
Workbook_Calculate was another shot I tried, but I can't see an easy way to determine whether my cells of interest are changed or not.
According to Excel Help, Worksheet_Change() should be my ideal solution, but it doesn't seem to fire when the value in linked cells changes.
Workbook_Calculate was another shot I tried, but I can't see an easy way to determine whether my cells of interest are changed or not.