Hi,
I have a cell A1 that has a model input that affects hundreds of other cells and I have a macro currently assigned to a button that copys and pastes some cells somewhere to refresh some of the data. I want to make it so that everytime the user either selects A1 or inputs a new number in A1 the macro automatically runs rather than having to remember to click the button. Ive tried assigning it to an autoshape hidden over the cell, but then it doesnt allow me to input anything into the cell because when i click it selects the autoshape rather than the cell.
Please let me know if you guys know of any way to do this and thank you in advance
Tim
Bookmarks