excel - How to stop loading Worksheet_Change function before running a macro? -
i have written macro collate data various sources in different sheets. want run track changes code here after collating data. however, since code within worksheet_change function, loading before running macro attached button. moment run macro, marking data changed. how can prevent happening? i figured out. added if conditional statement break out if conditions not met , wait macro check in.